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

3900: -------------
3901: CURSOR csr_tax_category (p_assignment_id NUMBER) IS
3902: SELECT segment13
3903: FROM per_all_assignments_f paa,
3904: hr_soft_coding_keyflex hsc
3905: WHERE paa.soft_coding_keyflex_id = hsc.soft_coding_keyflex_id
3906: AND p_date_earned BETWEEN paa.effective_start_date AND paa.effective_end_date
3907: AND paa.assignment_id = p_assignment_id;
3908: -------------

Line 3934: ,hr_soft_coding_keyflex hsck

3930:
3931: cursor csr_work_title (p_assignment_id NUMBER) IS
3932: SELECT hsck.segment4
3933: from per_all_assignments_f paaf
3934: ,hr_soft_coding_keyflex hsck
3935: where paaf.assignment_id= p_assignment_id
3936: and p_date_earned BETWEEN paaf.effective_start_date and paaf.effective_end_date
3937: and paaf.soft_coding_keyflex_id = hsck.soft_coding_keyflex_id;
3938: --------------

Line 3967: l_tax_category hr_soft_coding_keyflex.segment13%TYPE;

3963: l_ovn NUMBER ;
3964: l_rec get_details%ROWTYPE;
3965: l_tax_rec csr_tax_details%ROWTYPE;
3966: l_action_info_id pay_action_information.action_information_id%TYPE;
3967: l_tax_category hr_soft_coding_keyflex.segment13%TYPE;
3968: l_defined_balance_id pay_defined_balances.defined_balance_id%TYPE;
3969:
3970: l_work_title hr_soft_coding_keyflex.segment4%type := NULL ;
3971: l_net_salary_ptd NUMBER;

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

3966: l_action_info_id pay_action_information.action_information_id%TYPE;
3967: l_tax_category hr_soft_coding_keyflex.segment13%TYPE;
3968: l_defined_balance_id pay_defined_balances.defined_balance_id%TYPE;
3969:
3970: l_work_title hr_soft_coding_keyflex.segment4%type := NULL ;
3971: l_net_salary_ptd NUMBER;
3972: l_net_salary_ytd NUMBER;
3973: l_table_tax_basis_ptd NUMBER;
3974: l_table_tax_basis_ytd NUMBER;