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'),
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')
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
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
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;
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 ;