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

Line 872: per_all_assignments_f as1

868: pay_payroll_actions appa2,
869: pay_assignment_actions act,
870: pay_assignment_actions act1,
871: pay_action_interlocks pai,
872: per_all_assignments_f as1
873: WHERE ppa.payroll_action_id = p_payroll_action_id
874: AND appa.consolidation_set_id = p_consolidation_id
875: AND appa.effective_date BETWEEN l_canonical_start_date AND l_canonical_end_date
876: AND as1.person_id BETWEEN p_start_person AND p_end_person

Line 1408: per_all_assignments_f paa

1404: /* Cursor to pick Hire Date*/
1405: CURSOR csr_hire_date (p_assignment_id NUMBER) IS
1406: SELECT date_start
1407: FROM per_periods_of_service pps,
1408: per_all_assignments_f paa
1409: WHERE pps.period_of_service_id = paa.period_of_service_id
1410: AND p_date_earned between paa.effective_start_date and paa.effective_end_date
1411: AND paa.assignment_id = p_assignment_id;
1412: -------------

Line 1417: from per_all_assignments_f paaf

1413: /*Cursor to pick local unit*/
1414:
1415: cursor csr_scl_details (p_assignment_id NUMBER) IS
1416: SELECT segment2
1417: from per_all_assignments_f paaf
1418: ,HR_SOFT_CODING_KEYFLEX hsck
1419: where paaf.assignment_id= p_assignment_id
1420: and p_date_earned BETWEEN paaf.effective_start_date and paaf.effective_end_date
1421: and paaf.SOFT_CODING_KEYFLEX_ID = hsck.SOFT_CODING_KEYFLEX_ID;

Line 1444: FROM per_all_assignments_f asg1

1440: /* cursor to get the primary assignment id */
1441:
1442: CURSOR csr_get_prim_asg (p_date_earned DATE , p_asg_id NUMBER) IS
1443: SELECT asg2.assignment_id
1444: FROM per_all_assignments_f asg1
1445: ,per_all_assignments_f asg2
1446: WHERE asg1.assignment_id = p_asg_id
1447: AND asg1.person_id = asg2.person_id
1448: AND asg2.primary_flag = 'Y'

Line 1445: ,per_all_assignments_f asg2

1441:
1442: CURSOR csr_get_prim_asg (p_date_earned DATE , p_asg_id NUMBER) IS
1443: SELECT asg2.assignment_id
1444: FROM per_all_assignments_f asg1
1445: ,per_all_assignments_f asg2
1446: WHERE asg1.assignment_id = p_asg_id
1447: AND asg1.person_id = asg2.person_id
1448: AND asg2.primary_flag = 'Y'
1449: AND p_date_earned BETWEEN asg1.effective_start_date AND asg1.effective_end_date

Line 3842: per_all_assignments_f paa

3838: -------------
3839: CURSOR CSR_ACTUAL_TERM_DATE (p_assignment_id NUMBER) IS
3840: SELECT actual_termination_date
3841: FROM per_periods_of_service pps,
3842: per_all_assignments_f paa
3843: WHERE pps.period_of_service_id = paa.period_of_service_id
3844: AND p_date_earned between paa.effective_start_date and paa.effective_end_date
3845: AND paa.assignment_id = p_assignment_id;
3846: -------------

Line 3851: FROM per_all_assignments_f asg1

3847:
3848: CURSOR get_details(p_assignment_id NUMBER , p_input_value VARCHAR2 ) IS
3849: SELECT ee.effective_start_date effective_start_date
3850: ,eev1.screen_entry_value screen_entry_value
3851: FROM per_all_assignments_f asg1
3852: ,per_all_assignments_f asg2
3853: ,per_all_people_f per
3854: ,pay_element_links_f el
3855: ,pay_element_types_f et

Line 3852: ,per_all_assignments_f asg2

3848: CURSOR get_details(p_assignment_id NUMBER , p_input_value VARCHAR2 ) IS
3849: SELECT ee.effective_start_date effective_start_date
3850: ,eev1.screen_entry_value screen_entry_value
3851: FROM per_all_assignments_f asg1
3852: ,per_all_assignments_f asg2
3853: ,per_all_people_f per
3854: ,pay_element_links_f el
3855: ,pay_element_types_f et
3856: ,pay_input_values_f iv1

Line 3881: FROM per_all_assignments_f asg1

3877: ------------
3878: CURSOR csr_tax_details(p_assignment_id NUMBER, p_input_value VARCHAR2) IS
3879: SELECT ee.effective_start_date
3880: ,eev1.screen_entry_value screen_entry_value
3881: FROM per_all_assignments_f asg1
3882: ,pay_element_links_f el
3883: ,pay_element_types_f et
3884: ,pay_input_values_f iv1
3885: ,pay_element_entries_f ee

Line 3903: FROM per_all_assignments_f paa,

3899: AND p_date_earned BETWEEN eev1.effective_start_date AND eev1.effective_end_date;
3900: -------------
3901: CURSOR csr_tax_category (p_assignment_id NUMBER) IS
3902: SELECT segment13
3903: FROM per_all_assignments_f paa,
3904: hr_soft_coding_keyflex hsc
3905: WHERE paa.soft_coding_keyflex_id = hsc.soft_coding_keyflex_id
3906: AND p_date_earned BETWEEN paa.effective_start_date AND paa.effective_end_date
3907: AND paa.assignment_id = p_assignment_id;

Line 3933: from per_all_assignments_f paaf

3929: /* Cursor to get the Work Title from the assignment */
3930:
3931: cursor csr_work_title (p_assignment_id NUMBER) IS
3932: SELECT hsck.segment4
3933: from per_all_assignments_f paaf
3934: ,hr_soft_coding_keyflex hsck
3935: where paaf.assignment_id= p_assignment_id
3936: and p_date_earned BETWEEN paaf.effective_start_date and paaf.effective_end_date
3937: and paaf.soft_coding_keyflex_id = hsck.soft_coding_keyflex_id;

Line 4396: FROM per_all_assignments_f asg1

4392:
4393: -- Cursor to get the 'Tax Period Override Element' details
4394: CURSOR csr_tax_period_override (p_assignment_id NUMBER, p_input_value VARCHAR2) IS
4395: SELECT eev1.screen_entry_value screen_entry_value
4396: FROM per_all_assignments_f asg1
4397: ,pay_element_links_f el
4398: ,pay_element_types_f et
4399: ,pay_input_values_f iv1
4400: ,pay_element_entries_f ee