eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PAY_CA_EOY_RL1_ARCHIVE dependencies on PER_ALL_ASSIGNMENTS_F

Line 1116: FROM per_all_assignments_f ASG,

1112: CURSOR c_eoy_qbin IS
1113: SELECT ASG.person_id person_id,
1114: ASG.assignment_id assignment_id,
1115: ASG.effective_end_date effective_end_date
1116: FROM per_all_assignments_f ASG,
1117: pay_all_payrolls_f PPY,
1118: hr_soft_coding_keyflex SCL
1119: WHERE ASG.business_group_id + 0 = l_bus_group_id
1120: AND ASG.person_id between stperson and endperson

Line 1154: FROM per_all_assignments_f asg,

1150: CURSOR c_eoy_qbin IS
1151: SELECT asg.person_id person_id,
1152: asg.assignment_id assignment_id,
1153: asg.effective_end_date effective_end_date
1154: FROM per_all_assignments_f asg,
1155: pay_assignment_actions paa,
1156: pay_payroll_actions ppa
1157: WHERE ppa.effective_date between l_period_start
1158: and l_period_end

Line 1190: FROM per_all_assignments_f asg,

1186: CURSOR c_eoy_qbin_range IS
1187: SELECT asg.person_id person_id,
1188: asg.assignment_id assignment_id,
1189: asg.effective_end_date effective_end_date
1190: FROM per_all_assignments_f asg,
1191: pay_assignment_actions paa,
1192: pay_payroll_actions ppa,
1193: pay_population_ranges ppr
1194: WHERE ppa.effective_date between l_period_start

Line 1233: from per_all_assignments_f paf

1229: /* Get the primary assignment for the given person_id */
1230:
1231: CURSOR c_get_asg_id (p_person_id number) IS
1232: SELECT assignment_id
1233: from per_all_assignments_f paf
1234: where person_id = p_person_id
1235: and primary_flag = 'Y'
1236: and assignment_type = 'E'
1237: and paf.effective_start_date <= l_period_end

Line 1249: per_all_assignments_f paf,

1245: cp_period_start date,
1246: cp_period_end date) IS
1247: select paa.assignment_action_id
1248: from pay_assignment_actions paa,
1249: per_all_assignments_f paf,
1250: per_all_people_f ppf,
1251: pay_payroll_actions ppa,
1252: pay_action_classifications pac
1253: where ppf.person_id = cp_person_id

Line 2469: per_all_assignments_f paf,

2465: cp_period_end date
2466: ) IS
2467: select /*+ Ordered */ paa.assignment_action_id
2468: from per_all_people_f ppf,
2469: per_all_assignments_f paf,
2470: pay_assignment_actions paa,
2471: pay_payroll_actions ppa,
2472: pay_action_classifications pac,
2473: pay_action_contexts pac1,

Line 2994: per_all_assignments_f paf

2990: cursor c_all_gres_for_person(cp_asg_id number,cp_eff_date date) is
2991: select distinct paa.tax_unit_id
2992: from pay_assignment_actions paa,
2993: pay_payroll_actions ppa,
2994: per_all_assignments_f paf
2995: where paa.assignment_id = cp_asg_id
2996: and paf.assignment_id = cp_asg_id
2997: and paf.assignment_id = paa.assignment_id
2998: and paa.action_status = 'C'

Line 3080: , per_all_assignments_f arch_paf

3076: , pay_assignment_actions run_paa
3077: , pay_payroll_actions run_ppa
3078: , pay_assignment_actions arch_paa
3079: , pay_payroll_actions arch_ppa
3080: , per_all_assignments_f arch_paf
3081: , per_all_assignments_f all_paf
3082: , hr_all_organization_units hou
3083: , hr_organization_information hoi
3084: where arch_paa.assignment_action_id = cp_asgactid

Line 3081: , per_all_assignments_f all_paf

3077: , pay_payroll_actions run_ppa
3078: , pay_assignment_actions arch_paa
3079: , pay_payroll_actions arch_ppa
3080: , per_all_assignments_f arch_paf
3081: , per_all_assignments_f all_paf
3082: , hr_all_organization_units hou
3083: , hr_organization_information hoi
3084: where arch_paa.assignment_action_id = cp_asgactid
3085: and arch_ppa.payroll_action_id = arch_paa.payroll_action_id

Line 3185: per_all_assignments_f paf,

3181: cp_period_end date
3182: ) IS
3183: select /*+ Ordered */ paa.assignment_action_id
3184: from per_all_people_f ppf,
3185: per_all_assignments_f paf,
3186: pay_assignment_actions paa,
3187: pay_payroll_actions ppa,
3188: pay_action_classifications pac,
3189: pay_action_contexts pac1,

Line 3217: per_all_assignments_f paf,

3213: cp_period_start date,
3214: cp_period_end date) IS
3215: select paa.assignment_action_id
3216: from pay_assignment_actions paa,
3217: per_all_assignments_f paf,
3218: per_all_people_f ppf,
3219: pay_payroll_actions ppa,
3220: pay_action_classifications pac
3221: where ppf.person_id = cp_person_id

Line 4724: from per_all_assignments_f ASSIGN

4720: l_date_of_birth,
4721: l_national_identifier,
4722: l_pre_name_adjunct,
4723: l_employee_phone_no
4724: from per_all_assignments_f ASSIGN
4725: ,per_all_people_f PEOPLE
4726: ,per_person_types PTYPE
4727: ,per_phones PHONE
4728: ,fnd_sessions SES

Line 4761: from per_all_assignments_f ASSIGN

4757: l_employee_number,
4758: l_date_of_birth,
4759: l_national_identifier,
4760: l_pre_name_adjunct
4761: from per_all_assignments_f ASSIGN
4762: ,per_all_people_f PEOPLE
4763: where ASSIGN.assignment_id =l_asgid
4764: and PEOPLE.person_id = ASSIGN.person_id
4765: -- code fix started for 6440125

Line 5123: per_all_assignments_f asg,

5119: sqlstr := 'select distinct asg.person_id
5120: from pay_all_payrolls_f ppy,
5121: pay_payroll_actions ppa,
5122: pay_assignment_actions paa,
5123: per_all_assignments_f asg,
5124: pay_payroll_actions ppa1
5125: where ppa1.payroll_action_id = :payroll_action_id
5126: and ppa.effective_date between
5127: fnd_date.canonical_to_date('''||