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_NO_RULES dependencies on PER_ALL_ASSIGNMENTS_F

Line 12: l_business_group_id per_all_assignments_f.business_group_id%TYPE ;

8: (p_assignment_id IN NUMBER
9: ,p_effective_date IN DATE
10: ,p_tax_unit_id OUT NOCOPY NUMBER ) IS
11: l_local_unit_id hr_soft_coding_keyflex.SEGMENT2%TYPE ;
12: l_business_group_id per_all_assignments_f.business_group_id%TYPE ;
13: CURSOR c_local_unit_id IS
14: SELECT SCL.segment2 , business_group_id
15: FROM
16: per_all_assignments_f PAA ,

Line 16: per_all_assignments_f PAA ,

12: l_business_group_id per_all_assignments_f.business_group_id%TYPE ;
13: CURSOR c_local_unit_id IS
14: SELECT SCL.segment2 , business_group_id
15: FROM
16: per_all_assignments_f PAA ,
17: hr_soft_coding_keyflex SCL
18: WHERE ASSIGNMENT_ID = p_assignment_id
19: AND PAA.soft_coding_keyflex_id = SCL.soft_coding_keyflex_id
20: AND p_effective_date BETWEEN PAA.effective_start_date AND PAA.effective_end_date ;

Line 61: ,per_all_assignments_f paaf

57: FROM pay_element_entries_f pee
58: ,pay_element_entry_values_f eev
59: ,pay_input_values_f piv
60: ,pay_element_types_f pet
61: ,per_all_assignments_f paaf
62: ,pay_assignment_actions paa
63: ,pay_payroll_actions ppa
64: WHERE paa.assignment_action_id = p_assignment_action_id
65: AND ppa.payroll_action_id = paa.payroll_action_id

Line 120: FROM per_all_assignments_f asg1

116: AND pee.element_type_id = pet.element_type_id;
117:
118: CURSOR get_details_support_order(p_asg_act_id NUMBER ) IS
119: SELECT eev1.screen_entry_value screen_entry_value
120: FROM per_all_assignments_f asg1
121: ,per_all_assignments_f asg2
122: ,per_all_people_f per
123: ,pay_element_links_f el
124: ,pay_element_types_f et

Line 121: ,per_all_assignments_f asg2

117:
118: CURSOR get_details_support_order(p_asg_act_id NUMBER ) IS
119: SELECT eev1.screen_entry_value screen_entry_value
120: FROM per_all_assignments_f asg1
121: ,per_all_assignments_f asg2
122: ,per_all_people_f per
123: ,pay_element_links_f el
124: ,pay_element_types_f et
125: ,pay_input_values_f iv1

Line 167: FROM per_all_assignments_f asg1

163: AND asg1.assignment_id = pac.assignment_id;
164:
165: CURSOR get_details_tax_levy(p_asg_act_id NUMBER ) IS
166: SELECT eev1.screen_entry_value screen_entry_value
167: FROM per_all_assignments_f asg1
168: ,per_all_assignments_f asg2
169: ,per_all_people_f per
170: ,pay_element_links_f el
171: ,pay_element_types_f et

Line 168: ,per_all_assignments_f asg2

164:
165: CURSOR get_details_tax_levy(p_asg_act_id NUMBER ) IS
166: SELECT eev1.screen_entry_value screen_entry_value
167: FROM per_all_assignments_f asg1
168: ,per_all_assignments_f asg2
169: ,per_all_people_f per
170: ,pay_element_links_f el
171: ,pay_element_types_f et
172: ,pay_input_values_f iv1

Line 216: FROM per_all_assignments_f asg1

212:
213: --Added for bug fix 4372257
214: CURSOR get_details_union_dues(p_asg_act_id NUMBER ) IS
215: SELECT eev1.screen_entry_value screen_entry_value
216: FROM per_all_assignments_f asg1
217: ,per_all_assignments_f asg2
218: ,per_all_people_f per
219: ,pay_element_links_f el
220: ,pay_element_types_f et

Line 217: ,per_all_assignments_f asg2

213: --Added for bug fix 4372257
214: CURSOR get_details_union_dues(p_asg_act_id NUMBER ) IS
215: SELECT eev1.screen_entry_value screen_entry_value
216: FROM per_all_assignments_f asg1
217: ,per_all_assignments_f asg2
218: ,per_all_people_f per
219: ,pay_element_links_f el
220: ,pay_element_types_f et
221: ,pay_input_values_f iv1

Line 262: FROM per_all_assignments_f asg1

258: AND asg1.assignment_id = pac.assignment_id;
259:
260: CURSOR get_details_pension_element(p_asg_act_id NUMBER,p_element_name VARCHAR2 ) IS
261: SELECT eev1.screen_entry_value screen_entry_value
262: FROM per_all_assignments_f asg1
263: ,per_all_assignments_f asg2
264: ,per_all_people_f per
265: ,pay_element_links_f el
266: ,pay_element_types_f et

Line 263: ,per_all_assignments_f asg2

259:
260: CURSOR get_details_pension_element(p_asg_act_id NUMBER,p_element_name VARCHAR2 ) IS
261: SELECT eev1.screen_entry_value screen_entry_value
262: FROM per_all_assignments_f asg1
263: ,per_all_assignments_f asg2
264: ,per_all_people_f per
265: ,pay_element_links_f el
266: ,pay_element_types_f et
267: ,pay_input_values_f iv1

Line 351: per_all_assignments_f ASSIGN,

347: CURSOR csr_get_local_unit (p_assignment_action_id NUMBER) IS
348: select scl.segment2
349: from hr_soft_coding_keyflex scl,
350: pay_assignment_actions pac,
351: per_all_assignments_f ASSIGN,
352: pay_legislation_rules LEG,
353: fnd_id_flex_structures fstruct
354: Where pac.assignment_action_id = p_assignment_action_id
355: and pac.assignment_id = ASSIGN.assignment_id

Line 391: per_all_assignments_f ASSIGN,

387: IS
388: CURSOR csr_get_local_unit (p_assignment_id NUMBER) IS
389: select scl.segment2
390: from hr_soft_coding_keyflex scl,
391: per_all_assignments_f ASSIGN,
392: pay_legislation_rules LEG,
393: fnd_id_flex_structures fstruct
394: Where ASSIGN.assignment_id = p_assignment_id
395: and p_effective_date between ASSIGN.effective_start_date and ASSIGN.effective_end_date

Line 434: ,per_all_assignments_f paaf

430: FROM pay_element_entries_f pee
431: ,pay_element_entry_values_f eev
432: ,pay_input_values_f piv
433: ,pay_element_types_f pet
434: ,per_all_assignments_f paaf
435: ,pay_assignment_actions paa
436: ,pay_payroll_actions ppa
437: WHERE paa.assignment_action_id = p_assignment_action_id
438: AND ppa.payroll_action_id = paa.payroll_action_id

Line 464: FROM per_all_assignments_f asg1

460:
461: CURSOR csr_get_prim_asg_id (p_assignment_action_id NUMBER) IS
462: SELECT asg2.assignment_id
463: ,assact.payroll_action_id
464: FROM per_all_assignments_f asg1
465: ,per_all_assignments_f asg2
466: ,pay_assignment_actions assact
467: ,per_all_people_f pap
468: ,pay_payroll_actions ppa

Line 465: ,per_all_assignments_f asg2

461: CURSOR csr_get_prim_asg_id (p_assignment_action_id NUMBER) IS
462: SELECT asg2.assignment_id
463: ,assact.payroll_action_id
464: FROM per_all_assignments_f asg1
465: ,per_all_assignments_f asg2
466: ,pay_assignment_actions assact
467: ,per_all_people_f pap
468: ,pay_payroll_actions ppa
469: WHERE assact.assignment_action_id = p_assignment_action_id

Line 518: per_all_assignments_f paa ,

514:
515: CURSOR csr_get_lu_tax_mun (p_assignment_action_id NUMBER) IS
516: SELECT ORG_INFORMATION6 lu_tax_mun
517: FROM pay_assignment_actions assact ,
518: per_all_assignments_f paa ,
519: pay_payroll_actions ppa ,
520: hr_soft_coding_keyflex scl ,
521: hr_organization_information hoi
522: WHERE assact.assignment_action_id = p_assignment_action_id

Line 1392: FROM per_all_assignments_f asg1

1388:
1389: CURSOR csr_get_prim_asg_id (p_assignment_action_id NUMBER) IS
1390: SELECT asg2.assignment_id
1391: ,assact.payroll_action_id
1392: FROM per_all_assignments_f asg1
1393: ,per_all_assignments_f asg2
1394: ,pay_assignment_actions assact
1395: ,per_all_people_f pap
1396: ,pay_payroll_actions ppa

Line 1393: ,per_all_assignments_f asg2

1389: CURSOR csr_get_prim_asg_id (p_assignment_action_id NUMBER) IS
1390: SELECT asg2.assignment_id
1391: ,assact.payroll_action_id
1392: FROM per_all_assignments_f asg1
1393: ,per_all_assignments_f asg2
1394: ,pay_assignment_actions assact
1395: ,per_all_people_f pap
1396: ,pay_payroll_actions ppa
1397: WHERE assact.assignment_action_id = p_assignment_action_id