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

Line 845: ,HR_SOFT_CODING_KEYFLEX hsck

841: /*Cursor to pick local unit*/
842: cursor csr_scl_details (p_assignment_id NUMBER) IS
843: SELECT segment2
844: from per_all_assignments_f paaf
845: ,HR_SOFT_CODING_KEYFLEX hsck
846: where paaf.assignment_id= p_assignment_id
847: and p_date_earned BETWEEN paaf.effective_start_date and paaf.effective_end_date
848: and paaf.SOFT_CODING_KEYFLEX_ID = hsck.SOFT_CODING_KEYFLEX_ID;
849: rec_person_details csr_person_details%ROWTYPE;

Line 2413: hr_soft_coding_keyflex hsc

2409: AND p_date_earned BETWEEN eev1.effective_start_date AND eev1.effective_end_date;
2410: CURSOR csr_tax_category (p_assignment_id NUMBER) IS
2411: SELECT segment13
2412: FROM per_all_assignments_f paa,
2413: hr_soft_coding_keyflex hsc
2414: WHERE
2415: paa.soft_coding_keyflex_id = hsc.soft_coding_keyflex_id
2416: AND p_date_earned BETWEEN paa.effective_start_date
2417: AND paa.effective_end_date

Line 3753: ,HR_SOFT_CODING_KEYFLEX hsck

3749:
3750: CURSOR csr_scl_details (p_payroll_action_id pay_action_information.action_information1%TYPE , p_effective_date DATE ) IS
3751: SELECT DISTINCT segment2 local_unit , paaf.business_group_id
3752: FROM per_all_assignments_f paaf
3753: ,HR_SOFT_CODING_KEYFLEX hsck
3754: WHERE p_effective_date BETWEEN paaf.effective_start_date AND paaf.effective_end_date
3755: AND paaf.SOFT_CODING_KEYFLEX_ID = hsck.SOFT_CODING_KEYFLEX_ID
3756: AND paaf.assignment_id IN
3757: (SELECT DISTINCT assignment_id