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_FI_ARCHIVE_PYSA dependencies on HR_SOFT_CODING_KEYFLEX

Line 806: ,HR_SOFT_CODING_KEYFLEX hsck

802: /*Cursor to pick local unit*/
803: cursor csr_scl_details (p_assignment_id NUMBER) IS
804: SELECT segment2
805: from per_all_assignments_f paaf
806: ,HR_SOFT_CODING_KEYFLEX hsck
807: where paaf.assignment_id= p_assignment_id
808: and p_date_earned BETWEEN paaf.effective_start_date and paaf.effective_end_date
809: and paaf.SOFT_CODING_KEYFLEX_ID = hsck.SOFT_CODING_KEYFLEX_ID;
810: rec_person_details csr_person_details%ROWTYPE;

Line 1866: hr_soft_coding_keyflex hsc

1862: AND p_date_earned BETWEEN eev1.effective_start_date AND eev1.effective_end_date;
1863: CURSOR csr_tax_category (p_assignment_id NUMBER) IS
1864: SELECT segment13
1865: FROM per_all_assignments_f paa,
1866: hr_soft_coding_keyflex hsc
1867: WHERE
1868: paa.soft_coding_keyflex_id = hsc.soft_coding_keyflex_id
1869: AND p_date_earned BETWEEN paa.effective_start_date
1870: AND paa.effective_end_date

Line 2907: ,HR_SOFT_CODING_KEYFLEX hsck

2903:
2904: CURSOR csr_scl_details (p_payroll_action_id pay_action_information.action_information1%TYPE , p_effective_date DATE ) IS
2905: SELECT DISTINCT segment2 local_unit , paaf.business_group_id
2906: FROM per_all_assignments_f paaf
2907: ,HR_SOFT_CODING_KEYFLEX hsck
2908: WHERE p_effective_date BETWEEN paaf.effective_start_date AND paaf.effective_end_date
2909: AND paaf.SOFT_CODING_KEYFLEX_ID = hsck.SOFT_CODING_KEYFLEX_ID
2910: AND paaf.assignment_id IN
2911: (SELECT DISTINCT assignment_id