APPS.PAY_CA_EOY_RL2_ARCHIVE dependencies on PER_ALL_ASSIGNMENTS_F

Line 975: FROM per_all_assignments_f ASG,

971: CURSOR c_eoy_qbin IS
972: SELECT ASG.person_id person_id,
973: ASG.assignment_id assignment_id,
974: ASG.effective_end_date effective_end_date
975: FROM per_all_assignments_f ASG,
976: pay_all_payrolls_f PPY,
977: hr_soft_coding_keyflex SCL
978: WHERE ASG.business_group_id + 0 = l_bus_group_id
979: AND ASG.person_id between stperson and endperson

Line 1009: FROM per_all_assignments_f asg,

1005: CURSOR c_eoy_qbin IS
1006: SELECT asg.person_id person_id,
1007: asg.assignment_id assignment_id,
1008: asg.effective_end_date effective_end_date
1009: FROM per_all_assignments_f asg,
1010: pay_assignment_actions paa,
1011: pay_payroll_actions ppa
1012: WHERE ppa.effective_date between l_period_start
1013: and l_period_end

Line 1045: FROM per_all_assignments_f asg,

1041: CURSOR c_eoy_qbin_range IS
1042: SELECT asg.person_id person_id,
1043: asg.assignment_id assignment_id,
1044: asg.effective_end_date effective_end_date
1045: FROM per_all_assignments_f asg,
1046: pay_assignment_actions paa,
1047: pay_payroll_actions ppa,
1048: pay_population_ranges ppr
1049: WHERE ppa.effective_date between l_period_start

Line 1089: from per_all_assignments_f paf

1085: /* Get the assignment for the given person_id */
1086:
1087: CURSOR c_get_asg_id (p_person_id number) IS
1088: SELECT assignment_id
1089: from per_all_assignments_f paf
1090: where person_id = p_person_id
1091: and assignment_type = 'E'
1092: and primary_flag = 'Y'
1093: and paf.effective_start_date <= l_period_end

Line 1108: per_all_assignments_f paf,

1104: cp_period_start date,
1105: cp_period_end date) IS
1106: select paa.assignment_action_id
1107: from pay_assignment_actions paa,
1108: per_all_assignments_f paf,
1109: per_all_people_f ppf,
1110: pay_payroll_actions ppa,
1111: pay_action_classifications pac
1112: where ppf.person_id = cp_person_id

Line 2154: per_all_assignments_f paf,

2150: cp_period_start date,
2151: cp_period_end date) IS
2152: select paa.assignment_action_id
2153: from pay_assignment_actions paa,
2154: per_all_assignments_f paf,
2155: per_all_people_f ppf,
2156: pay_payroll_actions ppa,
2157: pay_action_classifications pac,
2158: pay_action_contexts pac1,

Line 2718: from per_all_assignments_f ASSIGN

2714: PEOPLE.employee_number,
2715: PEOPLE.date_of_birth,
2716: replace(PEOPLE.national_identifier,' '),
2717: PEOPLE.pre_name_adjunct
2718: from per_all_assignments_f ASSIGN
2719: ,per_all_people_f PEOPLE
2720: where ASSIGN.assignment_id = cp_asg_id
2721: and PEOPLE.person_id = ASSIGN.person_id
2722: and PEOPLE.effective_end_date =

Line 2737: per_all_assignments_f paf,

2733: cp_period_start date,
2734: cp_period_end date) IS
2735: select paa.assignment_action_id
2736: from pay_assignment_actions paa,
2737: per_all_assignments_f paf,
2738: per_all_people_f ppf,
2739: pay_payroll_actions ppa,
2740: pay_action_classifications pac,
2741: pay_action_contexts pac1,

Line 4087: per_all_assignments_f asg,

4083: sqlstr := 'select distinct asg.person_id
4084: from pay_all_payrolls_f ppy,
4085: pay_payroll_actions ppa,
4086: pay_assignment_actions paa,
4087: per_all_assignments_f asg,
4088: pay_payroll_actions ppa1
4089: where ppa1.payroll_action_id = :payroll_action_id
4090: and ppa.effective_date between
4091: fnd_date.canonical_to_date('''||