DBA Data[Home] [Help]

APPS.PAY_MX_PAYREG_PKG dependencies on PAY_PAYROLL_ACTIONS

Line 101: pay_payroll_actions ppa

97: ,assignment_action_id
98: ,'TRANSFER_GRE_ID=P'
99: ,tax_unit_id
100: FROM pay_assignment_actions paa,
101: pay_payroll_actions ppa
102: WHERE ppa.payroll_action_id = pay_magtape_generic.get_parameter_value(
103: 'TRANSFER_PAYROLL_ACTION_ID')
104: AND ppa.payroll_action_id = paa.payroll_action_id
105: AND paa.tax_unit_id = pay_magtape_generic.get_parameter_value(

Line 115: FROM pay_payroll_actions ppa2,

111: paa.assignment_id,
112: ppa.effective_date,
113: paa.tax_unit_id))),
114: (SELECT ppa2.effective_date
115: FROM pay_payroll_actions ppa2,
116: pay_assignment_actions paa2
117: WHERE paa2.assignment_action_id = to_number(substr(paa.serial_number,2))
118: and paa2.payroll_action_id = ppa2.payroll_action_id
119: and ppa2.action_type in ('R', 'Q', 'V', 'B')