APPS.PAY_DK_ARCHIVE dependencies on HR_SOFT_CODING_KEYFLEX

Line 1002: ,HR_SOFT_CODING_KEYFLEX hsck

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;
1006: */

Line 1013: ,HR_SOFT_CODING_KEYFLEX hsck

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;
1017:

Line 3151: hr_soft_coding_keyflex hsc

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;
3155: -------------

Line 3187: l_tax_category hr_soft_coding_keyflex.segment13%TYPE;

3183: l_ovn NUMBER ;
3184: l_rec get_details%ROWTYPE;
3185: l_tax_rec csr_tax_details%ROWTYPE;
3186: l_action_info_id pay_action_information.action_information_id%TYPE;
3187: l_tax_category hr_soft_coding_keyflex.segment13%TYPE;
3188: l_defined_balance_id pay_defined_balances.defined_balance_id%TYPE;
3189:
3190: -- Bug Fix 5081696
3191: l_global_tax_percent VARCHAR2(20);