APPS.PAY_NO_TAX_LEVY dependencies on PAY_NO_TAX_LEVY

Line 1: PACKAGE BODY PAY_NO_TAX_LEVY AS

1: PACKAGE BODY PAY_NO_TAX_LEVY AS
2: /* $Header: pynotaxlevy.pkb 120.5.12020000.2 2012/08/10 08:25:26 smeduri ship $ */
3: g_debug boolean := hr_utility.debug_enabled;
4: l_business_id NUMBER;
5: l_leg_emp_id NUMBER;

Line 68: SELECT PAY_NO_TAX_LEVY.GET_PARAMETER(legislative_parameters,'LEGAL_EMPLOYER_ID')

64: )IS
65:
66:
67: CURSOR csr_parameter_info(p_payroll_action_id NUMBER) IS
68: SELECT PAY_NO_TAX_LEVY.GET_PARAMETER(legislative_parameters,'LEGAL_EMPLOYER_ID')
69: ,PAY_NO_TAX_LEVY.GET_PARAMETER(legislative_parameters,'BIMONTH_TERM')
70: ,PAY_NO_TAX_LEVY.GET_PARAMETER(legislative_parameters,'ARCHIVE')
71: ,PAY_NO_TAX_LEVY.GET_PARAMETER(legislative_parameters,'THIRD_PARTY_PAYEE')
72: ,effective_date

Line 69: ,PAY_NO_TAX_LEVY.GET_PARAMETER(legislative_parameters,'BIMONTH_TERM')

65:
66:
67: CURSOR csr_parameter_info(p_payroll_action_id NUMBER) IS
68: SELECT PAY_NO_TAX_LEVY.GET_PARAMETER(legislative_parameters,'LEGAL_EMPLOYER_ID')
69: ,PAY_NO_TAX_LEVY.GET_PARAMETER(legislative_parameters,'BIMONTH_TERM')
70: ,PAY_NO_TAX_LEVY.GET_PARAMETER(legislative_parameters,'ARCHIVE')
71: ,PAY_NO_TAX_LEVY.GET_PARAMETER(legislative_parameters,'THIRD_PARTY_PAYEE')
72: ,effective_date
73: ,business_group_id

Line 70: ,PAY_NO_TAX_LEVY.GET_PARAMETER(legislative_parameters,'ARCHIVE')

66:
67: CURSOR csr_parameter_info(p_payroll_action_id NUMBER) IS
68: SELECT PAY_NO_TAX_LEVY.GET_PARAMETER(legislative_parameters,'LEGAL_EMPLOYER_ID')
69: ,PAY_NO_TAX_LEVY.GET_PARAMETER(legislative_parameters,'BIMONTH_TERM')
70: ,PAY_NO_TAX_LEVY.GET_PARAMETER(legislative_parameters,'ARCHIVE')
71: ,PAY_NO_TAX_LEVY.GET_PARAMETER(legislative_parameters,'THIRD_PARTY_PAYEE')
72: ,effective_date
73: ,business_group_id
74: FROM pay_payroll_actions

Line 71: ,PAY_NO_TAX_LEVY.GET_PARAMETER(legislative_parameters,'THIRD_PARTY_PAYEE')

67: CURSOR csr_parameter_info(p_payroll_action_id NUMBER) IS
68: SELECT PAY_NO_TAX_LEVY.GET_PARAMETER(legislative_parameters,'LEGAL_EMPLOYER_ID')
69: ,PAY_NO_TAX_LEVY.GET_PARAMETER(legislative_parameters,'BIMONTH_TERM')
70: ,PAY_NO_TAX_LEVY.GET_PARAMETER(legislative_parameters,'ARCHIVE')
71: ,PAY_NO_TAX_LEVY.GET_PARAMETER(legislative_parameters,'THIRD_PARTY_PAYEE')
72: ,effective_date
73: ,business_group_id
74: FROM pay_payroll_actions
75: WHERE payroll_action_id = p_payroll_action_id;

Line 150: PAY_NO_TAX_LEVY.GET_ALL_PARAMETERS(

146: AND ppa.business_group_id = ppf.business_group_id
147: ORDER BY ppf.person_id';
148:
149: -- fetch the data for the REPORT DETAILS
150: PAY_NO_TAX_LEVY.GET_ALL_PARAMETERS(
151: pactid
152: ,l_business_id
153: ,l_leg_emp_id
154: ,l_effective_date

Line 362: PAY_NO_TAX_LEVY.GET_ALL_PARAMETERS(

358: IF g_debug THEN
359: hr_utility.set_location(' Entering Procedure ASSIGNMENT_ACTION_CODE',60);
360: END IF;
361: -- fetch the data for the REPORT DETAILS
362: PAY_NO_TAX_LEVY.GET_ALL_PARAMETERS(
363: p_payroll_action_id
364: ,l_business_id
365: ,l_leg_emp_id
366: ,l_effective_date

Line 629: PAY_NO_TAX_LEVY.GET_ALL_PARAMETERS(

625: FETCH csr_get_act_info INTO l_action_info_id , l_main_asg_act_id ,l_new_payroll_action_id,l_payee_id;
626: CLOSE csr_get_act_info ;
627:
628: -- fetch the data for the REPORT DETAILS
629: PAY_NO_TAX_LEVY.GET_ALL_PARAMETERS(
630: l_new_payroll_action_id
631: ,l_business_id
632: ,l_leg_emp_id
633: ,l_effective_date

Line 950: END PAY_NO_TAX_LEVY;

946:
947: end write_to_clob;
948:
949: -------------------------------------------------------------------------------------------------------------------------
950: END PAY_NO_TAX_LEVY;