DBA Data[Home] [Help]

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.4.12000000.1 2007/05/20 08:06:12 rlingama noship $ */
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 361: PAY_NO_TAX_LEVY.GET_ALL_PARAMETERS(

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

Line 627: PAY_NO_TAX_LEVY.GET_ALL_PARAMETERS(

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

Line 948: END PAY_NO_TAX_LEVY;

944:
945: end write_to_clob;
946:
947: -------------------------------------------------------------------------------------------------------------------------
948: END PAY_NO_TAX_LEVY;