193: ppa.report_qualifier,
194: ppa.report_category,
195: ppa.business_group_id,
196: ppa.effective_date,
197: to_number(pay_core_utils.get_parameter('MONTH',ppa.legislative_parameters)) month_date,
198: to_number(pay_core_utils.get_parameter('LEGAL_ENTITY_ID',ppa.legislative_parameters)) legal_entity_id,
199: replace(pay_core_utils.get_parameter('CSN',ppa.legislative_parameters),'#',' ') csn,
200: to_date(pay_core_utils.get_parameter('MONTH',ppa.legislative_parameters)||'01','YYYYMMDD'),
201: last_day(to_date(pay_core_utils.get_parameter('MONTH',ppa.legislative_parameters)|| '01','YYYYMMDD'))
194: ppa.report_category,
195: ppa.business_group_id,
196: ppa.effective_date,
197: to_number(pay_core_utils.get_parameter('MONTH',ppa.legislative_parameters)) month_date,
198: to_number(pay_core_utils.get_parameter('LEGAL_ENTITY_ID',ppa.legislative_parameters)) legal_entity_id,
199: replace(pay_core_utils.get_parameter('CSN',ppa.legislative_parameters),'#',' ') csn,
200: to_date(pay_core_utils.get_parameter('MONTH',ppa.legislative_parameters)||'01','YYYYMMDD'),
201: last_day(to_date(pay_core_utils.get_parameter('MONTH',ppa.legislative_parameters)|| '01','YYYYMMDD'))
202: into g_pact
195: ppa.business_group_id,
196: ppa.effective_date,
197: to_number(pay_core_utils.get_parameter('MONTH',ppa.legislative_parameters)) month_date,
198: to_number(pay_core_utils.get_parameter('LEGAL_ENTITY_ID',ppa.legislative_parameters)) legal_entity_id,
199: replace(pay_core_utils.get_parameter('CSN',ppa.legislative_parameters),'#',' ') csn,
200: to_date(pay_core_utils.get_parameter('MONTH',ppa.legislative_parameters)||'01','YYYYMMDD'),
201: last_day(to_date(pay_core_utils.get_parameter('MONTH',ppa.legislative_parameters)|| '01','YYYYMMDD'))
202: into g_pact
203: from pay_payroll_actions ppa
196: ppa.effective_date,
197: to_number(pay_core_utils.get_parameter('MONTH',ppa.legislative_parameters)) month_date,
198: to_number(pay_core_utils.get_parameter('LEGAL_ENTITY_ID',ppa.legislative_parameters)) legal_entity_id,
199: replace(pay_core_utils.get_parameter('CSN',ppa.legislative_parameters),'#',' ') csn,
200: to_date(pay_core_utils.get_parameter('MONTH',ppa.legislative_parameters)||'01','YYYYMMDD'),
201: last_day(to_date(pay_core_utils.get_parameter('MONTH',ppa.legislative_parameters)|| '01','YYYYMMDD'))
202: into g_pact
203: from pay_payroll_actions ppa
204: where ppa.payroll_action_id = p_payroll_action_id;
197: to_number(pay_core_utils.get_parameter('MONTH',ppa.legislative_parameters)) month_date,
198: to_number(pay_core_utils.get_parameter('LEGAL_ENTITY_ID',ppa.legislative_parameters)) legal_entity_id,
199: replace(pay_core_utils.get_parameter('CSN',ppa.legislative_parameters),'#',' ') csn,
200: to_date(pay_core_utils.get_parameter('MONTH',ppa.legislative_parameters)||'01','YYYYMMDD'),
201: last_day(to_date(pay_core_utils.get_parameter('MONTH',ppa.legislative_parameters)|| '01','YYYYMMDD'))
202: into g_pact
203: from pay_payroll_actions ppa
204: where ppa.payroll_action_id = p_payroll_action_id;
205: end if ;
508: is
509: retain_archive_flag char(1) ;
510: begin
511: retain_archive_flag := 'N' ;
512: select pay_core_utils.get_parameter('RETAIN_ARCHIVE_DATA',ppa.legislative_parameters)
513: into retain_archive_flag
514: from pay_payroll_actions ppa
515: where ppa.payroll_action_id = p_payroll_action_id ;
516: --