APPS.PAY_DK_ARCHIVE dependencies on HR_SOFT_CODING_KEYFLEX

Line 993: ,HR_SOFT_CODING_KEYFLEX hsck

989: /*
990: cursor csr_scl_details (p_assignment_id NUMBER) IS
991: SELECT segment2
992: from per_all_assignments_f paaf
993: ,HR_SOFT_CODING_KEYFLEX hsck
994: where paaf.assignment_id= p_assignment_id
995: and p_date_earned BETWEEN paaf.effective_start_date and paaf.effective_end_date
996: and paaf.SOFT_CODING_KEYFLEX_ID = hsck.SOFT_CODING_KEYFLEX_ID;
997: */

Line 1004: ,HR_SOFT_CODING_KEYFLEX hsck

1000:
1001: cursor csr_scl_details (p_assignment_id NUMBER) IS
1002: SELECT segment1
1003: from per_all_assignments_f paaf
1004: ,HR_SOFT_CODING_KEYFLEX hsck
1005: where paaf.assignment_id= p_assignment_id
1006: and p_date_earned BETWEEN paaf.effective_start_date and paaf.effective_end_date
1007: and paaf.SOFT_CODING_KEYFLEX_ID = hsck.SOFT_CODING_KEYFLEX_ID;
1008:

Line 2709: hr_soft_coding_keyflex hsc

2705: -------------
2706: CURSOR csr_tax_category (p_assignment_id NUMBER) IS
2707: SELECT segment13
2708: FROM per_all_assignments_f paa,
2709: hr_soft_coding_keyflex hsc
2710: WHERE paa.soft_coding_keyflex_id = hsc.soft_coding_keyflex_id
2711: AND p_date_earned BETWEEN paa.effective_start_date AND paa.effective_end_date
2712: AND paa.assignment_id = p_assignment_id;
2713: -------------

Line 2745: l_tax_category hr_soft_coding_keyflex.segment13%TYPE;

2741: l_ovn NUMBER ;
2742: l_rec get_details%ROWTYPE;
2743: l_tax_rec csr_tax_details%ROWTYPE;
2744: l_action_info_id pay_action_information.action_information_id%TYPE;
2745: l_tax_category hr_soft_coding_keyflex.segment13%TYPE;
2746: l_defined_balance_id pay_defined_balances.defined_balance_id%TYPE;
2747:
2748: -- Bug Fix 5081696
2749: l_global_tax_percent VARCHAR2(20);