139: hr_utility.trace('Payroll_Action_Id '|| to_char(p_pactid));
140: SELECT ppa.start_date,
141: ppa.effective_date,
142: ppa.business_group_id,
143: pay_us_get_item_data_pkg.GET_CPROG_PARAMETER_VALUE(ppa.payroll_action_id,
144: 'TRANSFER_STATE'),
145: ppa.report_type,
146: pay_us_get_item_data_pkg.GET_CPROG_PARAMETER_VALUE(ppa.payroll_action_id,
147: 'LC')
142: ppa.business_group_id,
143: pay_us_get_item_data_pkg.GET_CPROG_PARAMETER_VALUE(ppa.payroll_action_id,
144: 'TRANSFER_STATE'),
145: ppa.report_type,
146: pay_us_get_item_data_pkg.GET_CPROG_PARAMETER_VALUE(ppa.payroll_action_id,
147: 'LC')
148: INTO p_year_start,
149: p_year_end,
150: p_business_group_id,
291: AND fdi.user_name = ''A_STATE_ABBREV''
292: AND fdi.user_entity_id = fai.user_entity_id
293: AND fai.archive_item_id = faic.archive_item_id
294: AND fai.context1 = paa.assignment_action_id
295: AND pus.STATE_ABBREV = pay_us_get_item_data_pkg.GET_CPROG_PARAMETER_VALUE(ppa1.payroll_action_id,
296: ''TRANSFER_STATE'')
297: AND fai.value = pus.STATE_ABBREV
298: AND paf.effective_start_date <= ppa.effective_date
299: AND paf.effective_end_date >= ppa.start_date