APPS.PAY_US_DEPOSIT_ADVICE_PKG dependencies on HR_ASSIGNMENT_SET

Line 606: lc_asg_flag := hr_assignment_set.assignment_in_set(

602: ln_assignment_id,
603: ln_tax_unit_id;
604: exit WHEN c_paid_actions%NOTFOUND;
605:
606: lc_asg_flag := hr_assignment_set.assignment_in_set(
607: ln_assignment_set_id,
608: ln_assignment_id);
609:
610: IF lc_asg_flag = 'Y' THEN

Line 730: hr_assignment_sets has,

726: pay_payroll_actions ppa_mag,
727: pay_org_payment_methods_f popm,
728: pay_all_payrolls_f ppf,
729: per_all_assignments_f paf2,
730: hr_assignment_sets has,
731: hr_assignment_set_amendments hasa
732: where ppa_dar.payroll_action_id = pactid
733: and has.assignment_set_id = p_assignment_set_id
734: and ppa_mag.effective_date between

Line 731: hr_assignment_set_amendments hasa

727: pay_org_payment_methods_f popm,
728: pay_all_payrolls_f ppf,
729: per_all_assignments_f paf2,
730: hr_assignment_sets has,
731: hr_assignment_set_amendments hasa
732: where ppa_dar.payroll_action_id = pactid
733: and has.assignment_set_id = p_assignment_set_id
734: and ppa_mag.effective_date between
735: ppa_dar.start_date and ppa_dar.effective_date

Line 850: l_asg_set_id hr_assignment_sets.assignment_set_id%TYPE;

846: ln_prev_source_action_id NUMBER := null;
847:
848: ln_master_action_id NUMBER;
849:
850: l_asg_set_id hr_assignment_sets.assignment_set_id%TYPE;
851:
852: ld_deposit_start_date DATE;
853: ld_deposit_end_date DATE;
854: ln_payroll_id NUMBER;

Line 1210: ,hr_assignment_set_amendments hasa

1206: ,pai.action_context_id
1207: FROM pay_assignment_actions paa
1208: ,pay_payroll_actions ppa
1209: ,hr_lookups hrl
1210: ,hr_assignment_set_amendments hasa
1211: ,pay_action_information pai
1212: ,per_time_periods ptp
1213: WHERE ppa.effective_Date BETWEEN c_start_date
1214: AND c_end_date

Line 1245: FROM hr_assignment_set_amendments

1241: --
1242: CURSOR csr_inc_exc(c_assignment_set_id NUMBER
1243: ,c_assignment_id NUMBER) IS
1244: SELECT include_or_exclude
1245: FROM hr_assignment_set_amendments
1246: WHERE assignment_set_id = c_assignment_set_id
1247: AND assignment_id = nvl(c_assignment_id,assignment_id);
1248: --
1249: --

Line 1482: hr_assignment_set_amendments hasa

1478: lv_sqlstr := 'select '||l_db_version||' distinct paf.person_id
1479: from pay_assignment_actions paa,
1480: pay_payroll_actions ppa,
1481: per_assignments_f paf,
1482: hr_assignment_set_amendments hasa
1483: where :payroll_action_id is not null
1484: and ppa.action_type in (''R'',''Q'')
1485: and paa.assignment_id = paf.assignment_id
1486: and ppa.consolidation_set_id = ' || ln_consolidation_set_id

Line 1517: hr_assignment_set_amendments hasa

1513: lv_sqlstr := 'select '||l_db_version||' distinct paf.person_id
1514: from pay_assignment_actions paa,
1515: pay_payroll_actions ppa,
1516: per_assignments_f paf,
1517: hr_assignment_set_amendments hasa
1518: where :payroll_action_id is not null
1519: and ppa.action_type in (''R'',''Q'')
1520: and paa.assignment_id = paf.assignment_id
1521: and ppa.consolidation_set_id = ' || ln_consolidation_set_id