APPS.PAY_NO_PAYSLIP_ARCHIVE dependencies on HR_SOFT_CODING_KEYFLEX

Line 1418: ,HR_SOFT_CODING_KEYFLEX hsck

1414:
1415: cursor csr_scl_details (p_assignment_id NUMBER) IS
1416: SELECT segment2
1417: from per_all_assignments_f paaf
1418: ,HR_SOFT_CODING_KEYFLEX hsck
1419: where paaf.assignment_id= p_assignment_id
1420: and p_date_earned BETWEEN paaf.effective_start_date and paaf.effective_end_date
1421: and paaf.SOFT_CODING_KEYFLEX_ID = hsck.SOFT_CODING_KEYFLEX_ID;
1422:

Line 3915: hr_soft_coding_keyflex hsc

3911: -------------
3912: CURSOR csr_tax_category (p_assignment_id NUMBER) IS
3913: SELECT segment13
3914: FROM per_all_assignments_f paa,
3915: hr_soft_coding_keyflex hsc
3916: WHERE paa.soft_coding_keyflex_id = hsc.soft_coding_keyflex_id
3917: AND p_date_earned BETWEEN paa.effective_start_date AND paa.effective_end_date
3918: AND paa.assignment_id = p_assignment_id;
3919: -------------

Line 3945: ,hr_soft_coding_keyflex hsck

3941:
3942: cursor csr_work_title (p_assignment_id NUMBER) IS
3943: SELECT hsck.segment4
3944: from per_all_assignments_f paaf
3945: ,hr_soft_coding_keyflex hsck
3946: where paaf.assignment_id= p_assignment_id
3947: and p_date_earned BETWEEN paaf.effective_start_date and paaf.effective_end_date
3948: and paaf.soft_coding_keyflex_id = hsck.soft_coding_keyflex_id;
3949: --------------

Line 3978: l_tax_category hr_soft_coding_keyflex.segment13%TYPE;

3974: l_ovn NUMBER ;
3975: l_rec get_details%ROWTYPE;
3976: l_tax_rec csr_tax_details%ROWTYPE;
3977: l_action_info_id pay_action_information.action_information_id%TYPE;
3978: l_tax_category hr_soft_coding_keyflex.segment13%TYPE;
3979: l_defined_balance_id pay_defined_balances.defined_balance_id%TYPE;
3980:
3981: l_work_title hr_soft_coding_keyflex.segment4%type := NULL ;
3982: l_net_salary_ptd NUMBER;

Line 3981: l_work_title hr_soft_coding_keyflex.segment4%type := NULL ;

3977: l_action_info_id pay_action_information.action_information_id%TYPE;
3978: l_tax_category hr_soft_coding_keyflex.segment13%TYPE;
3979: l_defined_balance_id pay_defined_balances.defined_balance_id%TYPE;
3980:
3981: l_work_title hr_soft_coding_keyflex.segment4%type := NULL ;
3982: l_net_salary_ptd NUMBER;
3983: l_net_salary_ytd NUMBER;
3984: l_table_tax_basis_ptd NUMBER;
3985: l_table_tax_basis_ytd NUMBER;