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.3.12000000.1 2007/05/20 07:58:20 rlingama noship $ */
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 362: PAY_NO_UNION_DUES.GET_ALL_PARAMETERS(

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

Line 611: PAY_NO_UNION_DUES.GET_ALL_PARAMETERS(

607: end;
608:
609:
610: -- fetch the data
611: PAY_NO_UNION_DUES.GET_ALL_PARAMETERS(
612: l_payroll_action_id
613: ,l_business_id
614: ,l_leg_emp_id
615: ,l_effective_date

Line 943: END PAY_NO_UNION_DUES;

939: end write_to_clob;
940: ------------------------------------------------------------------------------------------------------------
941:
942:
943: END PAY_NO_UNION_DUES;