APPS.PY_ROLLBACK_PKG dependencies on PAY_COSTS

Line 1831: from pay_costs pc

1827: SELECT count(DECODE(transfered_to_prj,'Y','YES',NULL)) AS prj_flg_yes_count,
1828: count(DECODE(transfered_to_prj,'N','No',NULL)) AS prj_flg_no_count,
1829: count(DECODE(transfered_to_prj,'X','X',NULL)) AS prj_flg_x_count
1830: INTO v_prj_flg_yes_count,v_prj_flg_no_count,v_prj_flg_x_count
1831: from pay_costs pc
1832: where pc.assignment_action_id = p_info.assact_id;
1833: --
1834: if(v_prj_flg_yes_count <> 0) then
1835: hr_utility.set_message(801, 'PAY_449895_STP_RETRY_RLBK_COST');

Line 1866: delete from pay_costs pc

1862: if g_debug then
1863: hr_utility.trace('Return status of projects audit API: ' || v_return_status);
1864: end if;
1865: -- Perform actual rollback
1866: delete from pay_costs pc
1867: where pc.assignment_action_id = p_info.assact_id;
1868: --
1869: ELSE
1870: --

Line 1875: delete from pay_costs pc

1871: if g_debug then
1872: hr_utility.set_location(c_indent, 22);
1873: end if;
1874: -- Perform only rollback
1875: delete from pay_costs pc
1876: where pc.assignment_action_id = p_info.assact_id;
1877: --
1878: end if;
1879: if g_debug then