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

Line 465: per_all_assignments_f as1

461: pay_payroll_actions appa2,
462: pay_assignment_actions act,
463: pay_assignment_actions act1,
464: pay_action_interlocks pai,
465: per_all_assignments_f as1
466: WHERE ppa.payroll_action_id = p_payroll_action_id
467: AND appa.consolidation_set_id = p_consolidation_id
468: AND appa.effective_date BETWEEN l_canonical_start_date AND l_canonical_end_date
469: AND as1.person_id BETWEEN p_start_person AND p_end_person

Line 992: per_all_assignments_f paa

988: /* Cursor to pick Hire Date*/
989: CURSOR csr_hire_date (p_assignment_id NUMBER) IS
990: SELECT date_start
991: FROM per_periods_of_service pps,
992: per_all_assignments_f paa
993: WHERE pps.period_of_service_id = paa.period_of_service_id
994: AND p_date_earned between paa.effective_start_date and paa.effective_end_date
995: AND paa.assignment_id = p_assignment_id;
996: -------------

Line 1001: from per_all_assignments_f paaf

997: /*Cursor to pick local unit*/
998: /*
999: cursor csr_scl_details (p_assignment_id NUMBER) IS
1000: SELECT segment2
1001: from per_all_assignments_f paaf
1002: ,HR_SOFT_CODING_KEYFLEX hsck
1003: where paaf.assignment_id= p_assignment_id
1004: and p_date_earned BETWEEN paaf.effective_start_date and paaf.effective_end_date
1005: and paaf.SOFT_CODING_KEYFLEX_ID = hsck.SOFT_CODING_KEYFLEX_ID;

Line 1012: from per_all_assignments_f paaf

1008: /*Cursor to pick Legal Employer */
1009:
1010: cursor csr_scl_details (p_assignment_id NUMBER) IS
1011: SELECT segment1
1012: from per_all_assignments_f paaf
1013: ,HR_SOFT_CODING_KEYFLEX hsck
1014: where paaf.assignment_id= p_assignment_id
1015: and p_date_earned BETWEEN paaf.effective_start_date and paaf.effective_end_date
1016: and paaf.SOFT_CODING_KEYFLEX_ID = hsck.SOFT_CODING_KEYFLEX_ID;

Line 3089: per_all_assignments_f paa

3085: -------------
3086: CURSOR CSR_ACTUAL_TERM_DATE (p_assignment_id NUMBER) IS
3087: SELECT actual_termination_date
3088: FROM per_periods_of_service pps,
3089: per_all_assignments_f paa
3090: WHERE pps.period_of_service_id = paa.period_of_service_id
3091: AND p_date_earned between paa.effective_start_date and paa.effective_end_date
3092: AND paa.assignment_id = p_assignment_id;
3093: -------------

Line 3098: FROM per_all_assignments_f asg1

3094:
3095: CURSOR get_details(p_assignment_id NUMBER , p_input_value VARCHAR2 ) IS
3096: SELECT ee.effective_start_date effective_start_date
3097: ,eev1.screen_entry_value screen_entry_value
3098: FROM per_all_assignments_f asg1
3099: ,per_all_assignments_f asg2
3100: ,per_all_people_f per
3101: ,pay_element_links_f el
3102: ,pay_element_types_f et

Line 3099: ,per_all_assignments_f asg2

3095: CURSOR get_details(p_assignment_id NUMBER , p_input_value VARCHAR2 ) IS
3096: SELECT ee.effective_start_date effective_start_date
3097: ,eev1.screen_entry_value screen_entry_value
3098: FROM per_all_assignments_f asg1
3099: ,per_all_assignments_f asg2
3100: ,per_all_people_f per
3101: ,pay_element_links_f el
3102: ,pay_element_types_f et
3103: ,pay_input_values_f iv1

Line 3128: FROM per_all_assignments_f asg1

3124: ------------
3125: CURSOR csr_tax_details(p_assignment_id NUMBER, p_input_value VARCHAR2) IS
3126: SELECT ee.effective_start_date
3127: ,eev1.screen_entry_value screen_entry_value
3128: FROM per_all_assignments_f asg1
3129: ,pay_element_links_f el
3130: ,pay_element_types_f et
3131: ,pay_input_values_f iv1
3132: ,pay_element_entries_f ee

Line 3150: FROM per_all_assignments_f paa,

3146: AND p_date_earned BETWEEN eev1.effective_start_date AND eev1.effective_end_date;
3147: -------------
3148: CURSOR csr_tax_category (p_assignment_id NUMBER) IS
3149: SELECT segment13
3150: FROM per_all_assignments_f paa,
3151: hr_soft_coding_keyflex hsc
3152: WHERE paa.soft_coding_keyflex_id = hsc.soft_coding_keyflex_id
3153: AND p_date_earned BETWEEN paa.effective_start_date AND paa.effective_end_date
3154: AND paa.assignment_id = p_assignment_id;

Line 3231: l_hourly_salaried per_all_assignments_f.hourly_salaried_code%TYPE ;

3227:
3228: l_payroll_id NUMBER;
3229: l_payroll_name VARCHAR2(80);
3230: l_period_type VARCHAR2(80);
3231: l_hourly_salaried per_all_assignments_f.hourly_salaried_code%TYPE ;
3232: --------------
3233: /*
3234: TYPE tax_card_rec IS RECORD (inp_val_name pay_input_values_f.NAME%type , screen_entry_val pay_input_values_f.NAME%type );
3235: