APPS.PAY_US_MMREF_LOCAL_XML dependencies on PAY_US_GET_ITEM_DATA_PKG

Line 142: pay_us_get_item_data_pkg.GET_CPROG_PARAMETER_VALUE(ppa.payroll_action_id,

138: hr_utility.trace('Payroll_Action_Id '|| to_char(p_pactid));
139: SELECT ppa.start_date,
140: ppa.effective_date,
141: ppa.business_group_id,
142: pay_us_get_item_data_pkg.GET_CPROG_PARAMETER_VALUE(ppa.payroll_action_id,
143: 'TRANSFER_STATE'),
144: ppa.report_type,
145: pay_us_get_item_data_pkg.GET_CPROG_PARAMETER_VALUE(ppa.payroll_action_id,
146: 'LC')

Line 145: pay_us_get_item_data_pkg.GET_CPROG_PARAMETER_VALUE(ppa.payroll_action_id,

141: ppa.business_group_id,
142: pay_us_get_item_data_pkg.GET_CPROG_PARAMETER_VALUE(ppa.payroll_action_id,
143: 'TRANSFER_STATE'),
144: ppa.report_type,
145: pay_us_get_item_data_pkg.GET_CPROG_PARAMETER_VALUE(ppa.payroll_action_id,
146: 'LC')
147: INTO p_year_start,
148: p_year_end,
149: p_business_group_id,

Line 294: AND pus.STATE_ABBREV = pay_us_get_item_data_pkg.GET_CPROG_PARAMETER_VALUE(ppa1.payroll_action_id,

290: AND fdi.user_name = ''A_STATE_ABBREV''
291: AND fdi.user_entity_id = fai.user_entity_id
292: AND fai.archive_item_id = faic.archive_item_id
293: AND fai.context1 = paa.assignment_action_id
294: AND pus.STATE_ABBREV = pay_us_get_item_data_pkg.GET_CPROG_PARAMETER_VALUE(ppa1.payroll_action_id,
295: ''TRANSFER_STATE'')
296: AND fai.value = pus.STATE_ABBREV
297: AND paf.effective_start_date <= ppa.effective_date
298: AND paf.effective_end_date >= ppa.start_date