APPS.PAY_CA_EOY_RL2_ARCHIVE dependencies on PER_ALL_ASSIGNMENTS_F

Line 908: FROM per_all_assignments_f ASG,

904: CURSOR c_eoy_qbin IS
905: SELECT ASG.person_id person_id,
906: ASG.assignment_id assignment_id,
907: ASG.effective_end_date effective_end_date
908: FROM per_all_assignments_f ASG,
909: pay_all_payrolls_f PPY,
910: hr_soft_coding_keyflex SCL
911: WHERE ASG.business_group_id + 0 = l_bus_group_id
912: AND ASG.person_id between stperson and endperson

Line 942: FROM per_all_assignments_f asg,

938: CURSOR c_eoy_qbin IS
939: SELECT asg.person_id person_id,
940: asg.assignment_id assignment_id,
941: asg.effective_end_date effective_end_date
942: FROM per_all_assignments_f asg,
943: pay_assignment_actions paa,
944: pay_payroll_actions ppa
945: WHERE ppa.effective_date between l_period_start
946: and l_period_end

Line 982: from per_all_assignments_f paf

978: /* Get the assignment for the given person_id */
979:
980: CURSOR c_get_asg_id (p_person_id number) IS
981: SELECT assignment_id
982: from per_all_assignments_f paf
983: where person_id = p_person_id
984: and assignment_type = 'E'
985: and primary_flag = 'Y'
986: and paf.effective_start_date <= l_period_end

Line 1001: per_all_assignments_f paf,

997: cp_period_start date,
998: cp_period_end date) IS
999: select paa.assignment_action_id
1000: from pay_assignment_actions paa,
1001: per_all_assignments_f paf,
1002: per_all_people_f ppf,
1003: pay_payroll_actions ppa,
1004: pay_action_classifications pac
1005: where ppf.person_id = cp_person_id

Line 2012: from per_all_assignments_f ASSIGN

2008: PEOPLE.employee_number,
2009: PEOPLE.date_of_birth,
2010: replace(PEOPLE.national_identifier,' '),
2011: PEOPLE.pre_name_adjunct
2012: from per_all_assignments_f ASSIGN
2013: ,per_all_people_f PEOPLE
2014: where ASSIGN.assignment_id = cp_asg_id
2015: and PEOPLE.person_id = ASSIGN.person_id
2016: and PEOPLE.effective_end_date =

Line 2031: per_all_assignments_f paf,

2027: cp_period_start date,
2028: cp_period_end date) IS
2029: select paa.assignment_action_id
2030: from pay_assignment_actions paa,
2031: per_all_assignments_f paf,
2032: per_all_people_f ppf,
2033: pay_payroll_actions ppa,
2034: pay_action_classifications pac,
2035: pay_action_contexts pac1,

Line 3240: per_all_assignments_f asg,

3236: sqlstr := 'select distinct asg.person_id
3237: from pay_all_payrolls_f ppy,
3238: pay_payroll_actions ppa,
3239: pay_assignment_actions paa,
3240: per_all_assignments_f asg,
3241: pay_payroll_actions ppa1
3242: where ppa1.payroll_action_id = :payroll_action_id
3243: and ppa.effective_date between
3244: fnd_date.canonical_to_date('''||