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 2425: hr_soft_coding_keyflex hsc

2421: AND p_date_earned BETWEEN eev1.effective_start_date AND eev1.effective_end_date;
2422: CURSOR csr_tax_category (p_assignment_id NUMBER) IS
2423: SELECT segment13
2424: FROM per_all_assignments_f paa,
2425: hr_soft_coding_keyflex hsc
2426: WHERE
2427: paa.soft_coding_keyflex_id = hsc.soft_coding_keyflex_id
2428: AND p_date_earned BETWEEN paa.effective_start_date
2429: AND paa.effective_end_date

Line 3778: ,HR_SOFT_CODING_KEYFLEX hsck

3774:
3775: CURSOR csr_scl_details (p_payroll_action_id pay_action_information.action_information1%TYPE , p_effective_date DATE ) IS
3776: SELECT DISTINCT segment2 local_unit , paaf.business_group_id
3777: FROM per_all_assignments_f paaf
3778: ,HR_SOFT_CODING_KEYFLEX hsck
3779: WHERE p_effective_date BETWEEN paaf.effective_start_date AND paaf.effective_end_date
3780: AND paaf.SOFT_CODING_KEYFLEX_ID = hsck.SOFT_CODING_KEYFLEX_ID
3781: AND paaf.assignment_id IN
3782: (SELECT DISTINCT assignment_id