APPS.PAY_US_DEPOSIT_ADVICE_PKG dependencies on HR_ASSIGNMENT_SET

Line 616: lc_asg_flag := hr_assignment_set.assignment_in_set(

612: ln_assignment_id,
613: ln_tax_unit_id;
614: exit WHEN c_paid_actions%NOTFOUND;
615:
616: lc_asg_flag := hr_assignment_set.assignment_in_set(
617: ln_assignment_set_id,
618: ln_assignment_id);
619:
620: IF lc_asg_flag = 'Y' THEN

Line 740: hr_assignment_sets has,

736: pay_payroll_actions ppa_mag,
737: pay_org_payment_methods_f popm,
738: pay_all_payrolls_f ppf,
739: per_all_assignments_f paf2,
740: hr_assignment_sets has,
741: hr_assignment_set_amendments hasa
742: where ppa_dar.payroll_action_id = pactid
743: and has.assignment_set_id = p_assignment_set_id
744: and ppa_mag.effective_date between

Line 741: hr_assignment_set_amendments hasa

737: pay_org_payment_methods_f popm,
738: pay_all_payrolls_f ppf,
739: per_all_assignments_f paf2,
740: hr_assignment_sets has,
741: hr_assignment_set_amendments hasa
742: where ppa_dar.payroll_action_id = pactid
743: and has.assignment_set_id = p_assignment_set_id
744: and ppa_mag.effective_date between
745: ppa_dar.start_date and ppa_dar.effective_date

Line 860: l_asg_set_id hr_assignment_sets.assignment_set_id%TYPE;

856: ln_prev_source_action_id NUMBER := null;
857:
858: ln_master_action_id NUMBER;
859:
860: l_asg_set_id hr_assignment_sets.assignment_set_id%TYPE;
861:
862: ld_deposit_start_date DATE;
863: ld_deposit_end_date DATE;
864: ln_payroll_id NUMBER;

Line 1220: ,hr_assignment_set_amendments hasa

1216: ,pai.action_context_id
1217: FROM pay_assignment_actions paa
1218: ,pay_payroll_actions ppa
1219: ,hr_lookups hrl
1220: ,hr_assignment_set_amendments hasa
1221: ,pay_action_information pai
1222: ,per_time_periods ptp
1223: WHERE ppa.effective_Date BETWEEN c_start_date
1224: AND c_end_date

Line 1255: FROM hr_assignment_set_amendments

1251: --
1252: CURSOR csr_inc_exc(c_assignment_set_id NUMBER
1253: ,c_assignment_id NUMBER) IS
1254: SELECT include_or_exclude
1255: FROM hr_assignment_set_amendments
1256: WHERE assignment_set_id = c_assignment_set_id
1257: AND assignment_id = nvl(c_assignment_id,assignment_id);
1258: --
1259: --

Line 1492: hr_assignment_set_amendments hasa

1488: lv_sqlstr := 'select '||l_db_version||' distinct paf.person_id
1489: from pay_assignment_actions paa,
1490: pay_payroll_actions ppa,
1491: per_assignments_f paf,
1492: hr_assignment_set_amendments hasa
1493: where :payroll_action_id is not null
1494: and ppa.action_type in (''R'',''Q'')
1495: and paa.assignment_id = paf.assignment_id
1496: and ppa.consolidation_set_id = ' || ln_consolidation_set_id

Line 1527: hr_assignment_set_amendments hasa

1523: lv_sqlstr := 'select '||l_db_version||' distinct paf.person_id
1524: from pay_assignment_actions paa,
1525: pay_payroll_actions ppa,
1526: per_assignments_f paf,
1527: hr_assignment_set_amendments hasa
1528: where :payroll_action_id is not null
1529: and ppa.action_type in (''R'',''Q'')
1530: and paa.assignment_id = paf.assignment_id
1531: and ppa.consolidation_set_id = ' || ln_consolidation_set_id