APPS.PAY_JP_GENERIC_UPGRADE_PKG dependencies on PAY_JP_PRE_TAX_OLD

Line 1227: from pay_jp_pre_tax_old ppt,

1223: c_proc constant varchar2(61) := c_package || 'validate_code_jp_pre_tax';
1224: --
1225: cursor csr_exists is
1226: select 'TRUE'
1227: from pay_jp_pre_tax_old ppt,
1228: pay_assignment_actions paa
1229: where paa.action_status = 'C'
1230: and ppt.assignment_action_id = paa.assignment_action_id
1231: and ppt.assignment_action_id NOT IN (

Line 1262: from pay_jp_pre_tax_old ppt,

1258: c_proc constant varchar2(61) := c_package || 'qualifying_jp_pre_tax';
1259: --
1260: cursor csr_ppt is
1261: select 'Y'
1262: from pay_jp_pre_tax_old ppt,
1263: pay_assignment_actions paa
1264: where paa.assignment_id = p_assignment_id
1265: and paa.action_status = 'C'
1266: and ppt.assignment_action_id = paa.assignment_action_id

Line 1308: from pay_jp_pre_tax_old ppt,

1304: l_ovn pay_action_information.object_version_number%TYPE;
1305: --
1306: cursor csr_pre_tax is
1307: select ppt.*, ppa.effective_date
1308: from pay_jp_pre_tax_old ppt,
1309: pay_assignment_actions paa,
1310: pay_payroll_actions ppa
1311: where paa.assignment_id = p_assignment_id
1312: and paa.assignment_action_id = ppt.assignment_action_id