175: ppa.report_qualifier,
176: ppa.report_category,
177: ppa.business_group_id,
178: ppa.effective_date,
179: to_number(pay_core_utils.get_parameter('MONTH',ppa.legislative_parameters)) month_date,
180: to_number(pay_core_utils.get_parameter('LEGAL_ENTITY_ID',ppa.legislative_parameters)) legal_entity_id,
181: to_date(pay_core_utils.get_parameter('MONTH',ppa.legislative_parameters)||'01','YYYYMMDD'),
182: last_day(to_date(pay_core_utils.get_parameter('MONTH',ppa.legislative_parameters)|| '01','YYYYMMDD'))
183: into g_pact
176: ppa.report_category,
177: ppa.business_group_id,
178: ppa.effective_date,
179: to_number(pay_core_utils.get_parameter('MONTH',ppa.legislative_parameters)) month_date,
180: to_number(pay_core_utils.get_parameter('LEGAL_ENTITY_ID',ppa.legislative_parameters)) legal_entity_id,
181: to_date(pay_core_utils.get_parameter('MONTH',ppa.legislative_parameters)||'01','YYYYMMDD'),
182: last_day(to_date(pay_core_utils.get_parameter('MONTH',ppa.legislative_parameters)|| '01','YYYYMMDD'))
183: into g_pact
184: from pay_payroll_actions ppa
177: ppa.business_group_id,
178: ppa.effective_date,
179: to_number(pay_core_utils.get_parameter('MONTH',ppa.legislative_parameters)) month_date,
180: to_number(pay_core_utils.get_parameter('LEGAL_ENTITY_ID',ppa.legislative_parameters)) legal_entity_id,
181: to_date(pay_core_utils.get_parameter('MONTH',ppa.legislative_parameters)||'01','YYYYMMDD'),
182: last_day(to_date(pay_core_utils.get_parameter('MONTH',ppa.legislative_parameters)|| '01','YYYYMMDD'))
183: into g_pact
184: from pay_payroll_actions ppa
185: where ppa.payroll_action_id = p_payroll_action_id;
178: ppa.effective_date,
179: to_number(pay_core_utils.get_parameter('MONTH',ppa.legislative_parameters)) month_date,
180: to_number(pay_core_utils.get_parameter('LEGAL_ENTITY_ID',ppa.legislative_parameters)) legal_entity_id,
181: to_date(pay_core_utils.get_parameter('MONTH',ppa.legislative_parameters)||'01','YYYYMMDD'),
182: last_day(to_date(pay_core_utils.get_parameter('MONTH',ppa.legislative_parameters)|| '01','YYYYMMDD'))
183: into g_pact
184: from pay_payroll_actions ppa
185: where ppa.payroll_action_id = p_payroll_action_id;
186: end if ;
452: is
453: retain_archive_flag char(1) ;
454: begin
455: retain_archive_flag := 'N' ;
456: select pay_core_utils.get_parameter('RETAIN_ARCHIVE_DATA',ppa.legislative_parameters)
457: into retain_archive_flag
458: from pay_payroll_actions ppa
459: where ppa.payroll_action_id = p_payroll_action_id ;
460: --