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 126: FROM per_all_assignments_f asg1

122: -- bug#8752864 fix ends
123:
124: CURSOR get_details_support_order(p_asg_act_id NUMBER ) IS
125: SELECT fnd_number.canonical_to_number(eev1.screen_entry_value) screen_entry_value
126: FROM per_all_assignments_f asg1
127: ,per_all_assignments_f asg2
128: ,per_all_people_f per
129: ,pay_element_links_f el
130: ,pay_element_types_f et

Line 127: ,per_all_assignments_f asg2

123:
124: CURSOR get_details_support_order(p_asg_act_id NUMBER ) IS
125: SELECT fnd_number.canonical_to_number(eev1.screen_entry_value) screen_entry_value
126: FROM per_all_assignments_f asg1
127: ,per_all_assignments_f asg2
128: ,per_all_people_f per
129: ,pay_element_links_f el
130: ,pay_element_types_f et
131: ,pay_input_values_f iv1

Line 173: FROM per_all_assignments_f asg1

169: AND asg1.assignment_id = pac.assignment_id;
170:
171: CURSOR get_details_tax_levy(p_asg_act_id NUMBER ) IS
172: SELECT fnd_number.canonical_to_number(eev1.screen_entry_value) screen_entry_value
173: FROM per_all_assignments_f asg1
174: ,per_all_assignments_f asg2
175: ,per_all_people_f per
176: ,pay_element_links_f el
177: ,pay_element_types_f et

Line 174: ,per_all_assignments_f asg2

170:
171: CURSOR get_details_tax_levy(p_asg_act_id NUMBER ) IS
172: SELECT fnd_number.canonical_to_number(eev1.screen_entry_value) screen_entry_value
173: FROM per_all_assignments_f asg1
174: ,per_all_assignments_f asg2
175: ,per_all_people_f per
176: ,pay_element_links_f el
177: ,pay_element_types_f et
178: ,pay_input_values_f iv1

Line 222: FROM per_all_assignments_f asg1

218:
219: --Added for bug fix 4372257
220: CURSOR get_details_union_dues(p_asg_act_id NUMBER ) IS
221: SELECT fnd_number.canonical_to_number(eev1.screen_entry_value) screen_entry_value
222: FROM per_all_assignments_f asg1
223: ,per_all_assignments_f asg2
224: ,per_all_people_f per
225: ,pay_element_links_f el
226: ,pay_element_types_f et

Line 223: ,per_all_assignments_f asg2

219: --Added for bug fix 4372257
220: CURSOR get_details_union_dues(p_asg_act_id NUMBER ) IS
221: SELECT fnd_number.canonical_to_number(eev1.screen_entry_value) screen_entry_value
222: FROM per_all_assignments_f asg1
223: ,per_all_assignments_f asg2
224: ,per_all_people_f per
225: ,pay_element_links_f el
226: ,pay_element_types_f et
227: ,pay_input_values_f iv1

Line 268: FROM per_all_assignments_f asg1

264: AND asg1.assignment_id = pac.assignment_id;
265:
266: CURSOR get_details_pension_element(p_asg_act_id NUMBER,p_element_name VARCHAR2 ) IS
267: SELECT fnd_number.canonical_to_number(eev1.screen_entry_value) screen_entry_value
268: FROM per_all_assignments_f asg1
269: ,per_all_assignments_f asg2
270: ,per_all_people_f per
271: ,pay_element_links_f el
272: ,pay_element_types_f et

Line 269: ,per_all_assignments_f asg2

265:
266: CURSOR get_details_pension_element(p_asg_act_id NUMBER,p_element_name VARCHAR2 ) IS
267: SELECT fnd_number.canonical_to_number(eev1.screen_entry_value) screen_entry_value
268: FROM per_all_assignments_f asg1
269: ,per_all_assignments_f asg2
270: ,per_all_people_f per
271: ,pay_element_links_f el
272: ,pay_element_types_f et
273: ,pay_input_values_f iv1

Line 357: per_all_assignments_f ASSIGN,

353: CURSOR csr_get_local_unit (p_assignment_action_id NUMBER) IS
354: select scl.segment2
355: from hr_soft_coding_keyflex scl,
356: pay_assignment_actions pac,
357: per_all_assignments_f ASSIGN,
358: pay_legislation_rules LEG,
359: fnd_id_flex_structures fstruct
360: Where pac.assignment_action_id = p_assignment_action_id
361: and pac.assignment_id = ASSIGN.assignment_id

Line 397: per_all_assignments_f ASSIGN,

393: IS
394: CURSOR csr_get_local_unit (p_assignment_id NUMBER) IS
395: select scl.segment2
396: from hr_soft_coding_keyflex scl,
397: per_all_assignments_f ASSIGN,
398: pay_legislation_rules LEG,
399: fnd_id_flex_structures fstruct
400: Where ASSIGN.assignment_id = p_assignment_id
401: and p_effective_date between ASSIGN.effective_start_date and ASSIGN.effective_end_date

Line 440: ,per_all_assignments_f paaf

436: FROM pay_element_entries_f pee
437: ,pay_element_entry_values_f eev
438: ,pay_input_values_f piv
439: ,pay_element_types_f pet
440: ,per_all_assignments_f paaf
441: ,pay_assignment_actions paa
442: ,pay_payroll_actions ppa
443: WHERE paa.assignment_action_id = p_assignment_action_id
444: AND ppa.payroll_action_id = paa.payroll_action_id

Line 470: FROM per_all_assignments_f asg1

466:
467: CURSOR csr_get_prim_asg_id (p_assignment_action_id NUMBER) IS
468: SELECT asg2.assignment_id
469: ,assact.payroll_action_id
470: FROM per_all_assignments_f asg1
471: ,per_all_assignments_f asg2
472: ,pay_assignment_actions assact
473: ,per_all_people_f pap
474: ,pay_payroll_actions ppa

Line 471: ,per_all_assignments_f asg2

467: CURSOR csr_get_prim_asg_id (p_assignment_action_id NUMBER) IS
468: SELECT asg2.assignment_id
469: ,assact.payroll_action_id
470: FROM per_all_assignments_f asg1
471: ,per_all_assignments_f asg2
472: ,pay_assignment_actions assact
473: ,per_all_people_f pap
474: ,pay_payroll_actions ppa
475: WHERE assact.assignment_action_id = p_assignment_action_id

Line 524: per_all_assignments_f paa ,

520:
521: CURSOR csr_get_lu_tax_mun (p_assignment_action_id NUMBER) IS
522: SELECT ORG_INFORMATION6 lu_tax_mun
523: FROM pay_assignment_actions assact ,
524: per_all_assignments_f paa ,
525: pay_payroll_actions ppa ,
526: hr_soft_coding_keyflex scl ,
527: hr_organization_information hoi
528: WHERE assact.assignment_action_id = p_assignment_action_id

Line 1405: FROM per_all_assignments_f asg1

1401:
1402: CURSOR csr_get_prim_asg_id (p_assignment_action_id NUMBER) IS
1403: SELECT asg2.assignment_id
1404: ,assact.payroll_action_id
1405: FROM per_all_assignments_f asg1
1406: ,per_all_assignments_f asg2
1407: ,pay_assignment_actions assact
1408: ,per_all_people_f pap
1409: ,pay_payroll_actions ppa

Line 1406: ,per_all_assignments_f asg2

1402: CURSOR csr_get_prim_asg_id (p_assignment_action_id NUMBER) IS
1403: SELECT asg2.assignment_id
1404: ,assact.payroll_action_id
1405: FROM per_all_assignments_f asg1
1406: ,per_all_assignments_f asg2
1407: ,pay_assignment_actions assact
1408: ,per_all_people_f pap
1409: ,pay_payroll_actions ppa
1410: WHERE assact.assignment_action_id = p_assignment_action_id