DBA Data[Home] [Help]

APPS.PAY_SG_AWCAP_ARCHIVE dependencies on PAY_CORE_UTILS

Line 191: pay_core_utils.get_parameter('RETAIN_ARCHIVE_DATA',legislative_parameters),

187: ppa.report_qualifier,
188: ppa.report_category,
189: ppa.business_group_id,
190: ppa.effective_date,
191: pay_core_utils.get_parameter('RETAIN_ARCHIVE_DATA',legislative_parameters),
192: pay_core_utils.get_parameter('PERSON_ID',legislative_parameters),
193: to_number(pay_core_utils.get_parameter('BASIS_YEAR',legislative_parameters)),
194: to_number(pay_core_utils.get_parameter('LEGAL_ENTITY_ID',ppa.legislative_parameters)) legal_entity_id,
195: to_date('01-01-'||pay_core_utils.get_parameter('BASIS_YEAR',legislative_parameters),'DD-MM-YYYY'),

Line 192: pay_core_utils.get_parameter('PERSON_ID',legislative_parameters),

188: ppa.report_category,
189: ppa.business_group_id,
190: ppa.effective_date,
191: pay_core_utils.get_parameter('RETAIN_ARCHIVE_DATA',legislative_parameters),
192: pay_core_utils.get_parameter('PERSON_ID',legislative_parameters),
193: to_number(pay_core_utils.get_parameter('BASIS_YEAR',legislative_parameters)),
194: to_number(pay_core_utils.get_parameter('LEGAL_ENTITY_ID',ppa.legislative_parameters)) legal_entity_id,
195: to_date('01-01-'||pay_core_utils.get_parameter('BASIS_YEAR',legislative_parameters),'DD-MM-YYYY'),
196: to_date('31-12-'|| pay_core_utils.get_parameter('BASIS_YEAR',legislative_parameters),'DD-MM-YYYY')

Line 193: to_number(pay_core_utils.get_parameter('BASIS_YEAR',legislative_parameters)),

189: ppa.business_group_id,
190: ppa.effective_date,
191: pay_core_utils.get_parameter('RETAIN_ARCHIVE_DATA',legislative_parameters),
192: pay_core_utils.get_parameter('PERSON_ID',legislative_parameters),
193: to_number(pay_core_utils.get_parameter('BASIS_YEAR',legislative_parameters)),
194: to_number(pay_core_utils.get_parameter('LEGAL_ENTITY_ID',ppa.legislative_parameters)) legal_entity_id,
195: to_date('01-01-'||pay_core_utils.get_parameter('BASIS_YEAR',legislative_parameters),'DD-MM-YYYY'),
196: to_date('31-12-'|| pay_core_utils.get_parameter('BASIS_YEAR',legislative_parameters),'DD-MM-YYYY')
197: into g_pact

Line 194: to_number(pay_core_utils.get_parameter('LEGAL_ENTITY_ID',ppa.legislative_parameters)) legal_entity_id,

190: ppa.effective_date,
191: pay_core_utils.get_parameter('RETAIN_ARCHIVE_DATA',legislative_parameters),
192: pay_core_utils.get_parameter('PERSON_ID',legislative_parameters),
193: to_number(pay_core_utils.get_parameter('BASIS_YEAR',legislative_parameters)),
194: to_number(pay_core_utils.get_parameter('LEGAL_ENTITY_ID',ppa.legislative_parameters)) legal_entity_id,
195: to_date('01-01-'||pay_core_utils.get_parameter('BASIS_YEAR',legislative_parameters),'DD-MM-YYYY'),
196: to_date('31-12-'|| pay_core_utils.get_parameter('BASIS_YEAR',legislative_parameters),'DD-MM-YYYY')
197: into g_pact
198: from pay_payroll_actions ppa

Line 195: to_date('01-01-'||pay_core_utils.get_parameter('BASIS_YEAR',legislative_parameters),'DD-MM-YYYY'),

191: pay_core_utils.get_parameter('RETAIN_ARCHIVE_DATA',legislative_parameters),
192: pay_core_utils.get_parameter('PERSON_ID',legislative_parameters),
193: to_number(pay_core_utils.get_parameter('BASIS_YEAR',legislative_parameters)),
194: to_number(pay_core_utils.get_parameter('LEGAL_ENTITY_ID',ppa.legislative_parameters)) legal_entity_id,
195: to_date('01-01-'||pay_core_utils.get_parameter('BASIS_YEAR',legislative_parameters),'DD-MM-YYYY'),
196: to_date('31-12-'|| pay_core_utils.get_parameter('BASIS_YEAR',legislative_parameters),'DD-MM-YYYY')
197: into g_pact
198: from pay_payroll_actions ppa
199: where ppa.payroll_action_id = p_payroll_action_id;

Line 196: to_date('31-12-'|| pay_core_utils.get_parameter('BASIS_YEAR',legislative_parameters),'DD-MM-YYYY')

192: pay_core_utils.get_parameter('PERSON_ID',legislative_parameters),
193: to_number(pay_core_utils.get_parameter('BASIS_YEAR',legislative_parameters)),
194: to_number(pay_core_utils.get_parameter('LEGAL_ENTITY_ID',ppa.legislative_parameters)) legal_entity_id,
195: to_date('01-01-'||pay_core_utils.get_parameter('BASIS_YEAR',legislative_parameters),'DD-MM-YYYY'),
196: to_date('31-12-'|| pay_core_utils.get_parameter('BASIS_YEAR',legislative_parameters),'DD-MM-YYYY')
197: into g_pact
198: from pay_payroll_actions ppa
199: where ppa.payroll_action_id = p_payroll_action_id;
200: end if ;