APPS.PAY_CA_YEPP_ADD_ACTIONS_PKG dependencies on HR_ASSIGNMENT_SET_AMENDMENTS

Line 512: from hr_assignment_set_amendments has,

508: IS
509:
510: cursor c_get_person_id (cp_assign_set_id number) is
511: select distinct paf.person_id
512: from hr_assignment_set_amendments has,
513: per_all_assignments_f paf
514: where has.assignment_set_id = cp_assign_set_id
515: and has.include_or_exclude = 'I'
516: and paf.assignment_id = has.assignment_id

Line 798: from hr_assignment_set_amendments has,

794: IS
795:
796: cursor c_get_person_id (cp_assign_set_id number) is
797: select distinct paf.person_id
798: from hr_assignment_set_amendments has,
799: per_all_assignments_f paf
800: where has.assignment_set_id = cp_assign_set_id
801: and has.include_or_exclude = 'I'
802: and paf.assignment_id = has.assignment_id

Line 1059: from hr_assignment_set_amendments has,

1055: cursor c_get_processed_asg_fed(cp_effective_date date,
1056: cp_gre_id number,
1057: cp_assignment_set_id number) is
1058: select distinct has.assignment_id
1059: from hr_assignment_set_amendments has,
1060: per_all_assignments_f paf
1061: where has.assignment_set_id = cp_assignment_set_id
1062: and paf.assignment_id = has.assignment_id
1063: and paf.assignment_type = 'E'

Line 1084: from hr_assignment_set_amendments has,

1080: cursor c_get_processed_asg_prov(cp_effective_date date,
1081: cp_pre_id number,
1082: cp_assignment_set_id number) is
1083: select distinct has.assignment_id
1084: from hr_assignment_set_amendments has,
1085: per_all_assignments_f paf
1086: where has.assignment_set_id = cp_assignment_set_id
1087: and paf.assignment_id = has.assignment_id
1088: and paf.assignment_type = 'E'

Line 1187: from hr_assignment_set_amendments has,

1183: cursor c_get_assignments(cp_assignment_set_id number,
1184: cp_gre_id number,
1185: cp_effective_date date) is
1186: select distinct has.assignment_id
1187: from hr_assignment_set_amendments has,
1188: per_all_assignments_f paf,
1189: pay_assignment_actions paa,
1190: pay_payroll_actions ppa
1191: where has.assignment_set_id = cp_assignment_set_id

Line 1354: from hr_assignment_set_amendments has,

1350: cursor c_secondary_asg_fed(cp_assignment_set_id number,
1351: cp_gre_id number,
1352: cp_effective_date date) is
1353: select distinct has.assignment_id
1354: from hr_assignment_set_amendments has,
1355: per_all_assignments_f paf,
1356: pay_assignment_actions paa,
1357: pay_payroll_actions ppa
1358: where has.assignment_set_id = cp_assignment_set_id

Line 1378: from hr_assignment_set_amendments has,

1374: cursor c_secondary_asg_prov(cp_assignment_set_id number,
1375: cp_pre_id number,
1376: cp_effective_date date) is
1377: select distinct has.assignment_id
1378: from hr_assignment_set_amendments has,
1379: per_all_assignments_f paf,
1380: pay_assignment_actions paa,
1381: pay_payroll_actions ppa
1382: where has.assignment_set_id = cp_assignment_set_id

Line 1541: from hr_assignment_set_amendments has,

1537: cp_gre_id number,
1538: cp_effective_date date) is
1539: select distinct has.assignment_id,
1540: paa.tax_unit_id
1541: from hr_assignment_set_amendments has,
1542: per_all_assignments_f paf,
1543: pay_assignment_actions paa,
1544: pay_payroll_actions ppa
1545: where has.assignment_set_id = cp_assignment_set_id

Line 1565: from hr_assignment_set_amendments has,

1561: cp_pre_id number,
1562: cp_effective_date date) is
1563: select distinct has.assignment_id,
1564: hoi.org_information2
1565: from hr_assignment_set_amendments has,
1566: per_all_assignments_f paf,
1567: pay_assignment_actions paa,
1568: pay_payroll_actions ppa,
1569: hr_organization_information hoi