DBA Data[Home] [Help]

APPS.PAY_KR_HIA_PKG dependencies on PAY_CORE_UTILS

Line 77: pay_core_utils.get_parameter('BP_HI_NUMBER',ppa.legislative_parameters) bp_hi_number, --3506171

73: ppa.report_qualifier,
74: ppa.report_category,
75: ppa.business_group_id,
76: ppa.effective_date,
77: pay_core_utils.get_parameter('BP_HI_NUMBER',ppa.legislative_parameters) bp_hi_number, --3506171
78: fnd_date.canonical_to_date(pay_core_utils.get_parameter('REPORTED_DATE',ppa.legislative_parameters)) reported_date,
79: trunc(fnd_date.canonical_to_date(pay_core_utils.get_parameter('REPORTED_DATE',ppa.legislative_parameters)),'YYYY') year_start_date
80: into g_pact
81: from pay_payroll_actions ppa

Line 78: fnd_date.canonical_to_date(pay_core_utils.get_parameter('REPORTED_DATE',ppa.legislative_parameters)) reported_date,

74: ppa.report_category,
75: ppa.business_group_id,
76: ppa.effective_date,
77: pay_core_utils.get_parameter('BP_HI_NUMBER',ppa.legislative_parameters) bp_hi_number, --3506171
78: fnd_date.canonical_to_date(pay_core_utils.get_parameter('REPORTED_DATE',ppa.legislative_parameters)) reported_date,
79: trunc(fnd_date.canonical_to_date(pay_core_utils.get_parameter('REPORTED_DATE',ppa.legislative_parameters)),'YYYY') year_start_date
80: into g_pact
81: from pay_payroll_actions ppa
82: where ppa.payroll_action_id = p_payroll_action_id;

Line 79: trunc(fnd_date.canonical_to_date(pay_core_utils.get_parameter('REPORTED_DATE',ppa.legislative_parameters)),'YYYY') year_start_date

75: ppa.business_group_id,
76: ppa.effective_date,
77: pay_core_utils.get_parameter('BP_HI_NUMBER',ppa.legislative_parameters) bp_hi_number, --3506171
78: fnd_date.canonical_to_date(pay_core_utils.get_parameter('REPORTED_DATE',ppa.legislative_parameters)) reported_date,
79: trunc(fnd_date.canonical_to_date(pay_core_utils.get_parameter('REPORTED_DATE',ppa.legislative_parameters)),'YYYY') year_start_date
80: into g_pact
81: from pay_payroll_actions ppa
82: where ppa.payroll_action_id = p_payroll_action_id;
83: END IF;

Line 146: trunc(fnd_date.canonical_to_date(pay_core_utils.get_parameter('REPORTED_DATE',xppa.legislative_parameters)), 'YYYY')

142: AND EXISTS (SELECT NULL
143: FROM pay_payroll_actions ppa,
144: pay_assignment_actions paa
145: WHERE ppa.effective_date BETWEEN
146: trunc(fnd_date.canonical_to_date(pay_core_utils.get_parameter('REPORTED_DATE',xppa.legislative_parameters)), 'YYYY')
147: AND fnd_date.canonical_to_date(pay_core_utils.get_parameter('REPORTED_DATE',xppa.legislative_parameters))
148: AND ppa.action_type in ('R','Q')
149: AND paa.action_status = 'C'
150: AND paa.payroll_action_id = ppa.payroll_action_id

Line 147: AND fnd_date.canonical_to_date(pay_core_utils.get_parameter('REPORTED_DATE',xppa.legislative_parameters))

143: FROM pay_payroll_actions ppa,
144: pay_assignment_actions paa
145: WHERE ppa.effective_date BETWEEN
146: trunc(fnd_date.canonical_to_date(pay_core_utils.get_parameter('REPORTED_DATE',xppa.legislative_parameters)), 'YYYY')
147: AND fnd_date.canonical_to_date(pay_core_utils.get_parameter('REPORTED_DATE',xppa.legislative_parameters))
148: AND ppa.action_type in ('R','Q')
149: AND paa.action_status = 'C'
150: AND paa.payroll_action_id = ppa.payroll_action_id
151: AND paa.source_action_id IS NULL