APPS.PAY_NO_UNION_DUES dependencies on PAY_NO_UNION_DUES

Line 1: PACKAGE BODY PAY_NO_UNION_DUES AS

1: PACKAGE BODY PAY_NO_UNION_DUES AS
2: /* $Header: pynouniondues.pkb 120.4.12020000.6 2012/10/31 12:47:40 dakhuran ship $ */
3:
4: g_debug boolean := hr_utility.debug_enabled;
5: l_business_id NUMBER;

Line 73: SELECT PAY_NO_UNION_DUES.GET_PARAMETER(legislative_parameters,'LEGAL_EMPLOYER_ID')

69: )IS
70:
71:
72: CURSOR csr_parameter_info(p_payroll_action_id NUMBER) IS
73: SELECT PAY_NO_UNION_DUES.GET_PARAMETER(legislative_parameters,'LEGAL_EMPLOYER_ID')
74: ,PAY_NO_UNION_DUES.GET_PARAMETER(legislative_parameters,'ARCHIVE')
75: ,PAY_NO_UNION_DUES.GET_PARAMETER(legislative_parameters,'THIRD_PARTY_PAYEE')
76: ,fnd_date.canonical_to_date(PAY_NO_UNION_DUES.GET_PARAMETER(legislative_parameters,'FROM_DATE'))
77: ,fnd_date.canonical_to_date(PAY_NO_UNION_DUES.GET_PARAMETER(legislative_parameters,'TO_DATE'))

Line 74: ,PAY_NO_UNION_DUES.GET_PARAMETER(legislative_parameters,'ARCHIVE')

70:
71:
72: CURSOR csr_parameter_info(p_payroll_action_id NUMBER) IS
73: SELECT PAY_NO_UNION_DUES.GET_PARAMETER(legislative_parameters,'LEGAL_EMPLOYER_ID')
74: ,PAY_NO_UNION_DUES.GET_PARAMETER(legislative_parameters,'ARCHIVE')
75: ,PAY_NO_UNION_DUES.GET_PARAMETER(legislative_parameters,'THIRD_PARTY_PAYEE')
76: ,fnd_date.canonical_to_date(PAY_NO_UNION_DUES.GET_PARAMETER(legislative_parameters,'FROM_DATE'))
77: ,fnd_date.canonical_to_date(PAY_NO_UNION_DUES.GET_PARAMETER(legislative_parameters,'TO_DATE'))
78: ,effective_date

Line 75: ,PAY_NO_UNION_DUES.GET_PARAMETER(legislative_parameters,'THIRD_PARTY_PAYEE')

71:
72: CURSOR csr_parameter_info(p_payroll_action_id NUMBER) IS
73: SELECT PAY_NO_UNION_DUES.GET_PARAMETER(legislative_parameters,'LEGAL_EMPLOYER_ID')
74: ,PAY_NO_UNION_DUES.GET_PARAMETER(legislative_parameters,'ARCHIVE')
75: ,PAY_NO_UNION_DUES.GET_PARAMETER(legislative_parameters,'THIRD_PARTY_PAYEE')
76: ,fnd_date.canonical_to_date(PAY_NO_UNION_DUES.GET_PARAMETER(legislative_parameters,'FROM_DATE'))
77: ,fnd_date.canonical_to_date(PAY_NO_UNION_DUES.GET_PARAMETER(legislative_parameters,'TO_DATE'))
78: ,effective_date
79: ,business_group_id

Line 76: ,fnd_date.canonical_to_date(PAY_NO_UNION_DUES.GET_PARAMETER(legislative_parameters,'FROM_DATE'))

72: CURSOR csr_parameter_info(p_payroll_action_id NUMBER) IS
73: SELECT PAY_NO_UNION_DUES.GET_PARAMETER(legislative_parameters,'LEGAL_EMPLOYER_ID')
74: ,PAY_NO_UNION_DUES.GET_PARAMETER(legislative_parameters,'ARCHIVE')
75: ,PAY_NO_UNION_DUES.GET_PARAMETER(legislative_parameters,'THIRD_PARTY_PAYEE')
76: ,fnd_date.canonical_to_date(PAY_NO_UNION_DUES.GET_PARAMETER(legislative_parameters,'FROM_DATE'))
77: ,fnd_date.canonical_to_date(PAY_NO_UNION_DUES.GET_PARAMETER(legislative_parameters,'TO_DATE'))
78: ,effective_date
79: ,business_group_id
80: FROM pay_payroll_actions

Line 77: ,fnd_date.canonical_to_date(PAY_NO_UNION_DUES.GET_PARAMETER(legislative_parameters,'TO_DATE'))

73: SELECT PAY_NO_UNION_DUES.GET_PARAMETER(legislative_parameters,'LEGAL_EMPLOYER_ID')
74: ,PAY_NO_UNION_DUES.GET_PARAMETER(legislative_parameters,'ARCHIVE')
75: ,PAY_NO_UNION_DUES.GET_PARAMETER(legislative_parameters,'THIRD_PARTY_PAYEE')
76: ,fnd_date.canonical_to_date(PAY_NO_UNION_DUES.GET_PARAMETER(legislative_parameters,'FROM_DATE'))
77: ,fnd_date.canonical_to_date(PAY_NO_UNION_DUES.GET_PARAMETER(legislative_parameters,'TO_DATE'))
78: ,effective_date
79: ,business_group_id
80: FROM pay_payroll_actions
81: WHERE payroll_action_id = p_payroll_action_id;

Line 151: PAY_NO_UNION_DUES.GET_ALL_PARAMETERS(

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

Line 363: PAY_NO_UNION_DUES.GET_ALL_PARAMETERS(

359: END IF;
360:
361:
362: -- fetch the data
363: PAY_NO_UNION_DUES.GET_ALL_PARAMETERS(
364: p_payroll_action_id
365: ,l_business_id
366: ,l_leg_emp_id
367: ,l_effective_date

Line 614: PAY_NO_UNION_DUES.GET_ALL_PARAMETERS(

610: end;
611:
612:
613: -- fetch the data
614: PAY_NO_UNION_DUES.GET_ALL_PARAMETERS(
615: l_payroll_action_id
616: ,l_business_id
617: ,l_leg_emp_id
618: ,l_effective_date

Line 996: END PAY_NO_UNION_DUES;

992: END get_union_due_global;
993:
994: ------------------------------------------------------------------------------------------------------------
995:
996: END PAY_NO_UNION_DUES;