APPS.PQH_PTX_BUS dependencies on PQH_PTX_EXTRA_INFO

Line 1711: from pqh_ptx_extra_info

1707: l_position_family varchar2(100);
1708: l_chk boolean := false;
1709: cursor c1 is
1710: select information3
1711: from pqh_ptx_extra_info
1712: where position_transaction_id = p_position_transaction_id
1713: and information_type = 'PER_FAMILY'
1714: and information3 in ('ACADEMIC','FACULTY');
1715: begin

Line 1937: from pqh_ptx_extra_info

1933: l_api_updating boolean;
1934:
1935: cursor c_seasonal is
1936: select 'X'
1937: from pqh_ptx_extra_info
1938: where position_transaction_id = nvl(p_position_transaction_id,-1)
1939: and information_type = 'PER_SEASONAL';
1940: begin
1941: l_api_updating := pqh_ptx_shd.api_updating

Line 1972: from pqh_ptx_extra_info

1968: l_api_updating boolean;
1969: --
1970: cursor c_overlap is
1971: select 'X'
1972: from pqh_ptx_extra_info
1973: where position_transaction_id = p_position_transaction_id
1974: and information_type = 'PER_OVERLAP';
1975: begin
1976: hr_utility.set_location('Entering:'||l_proc,10);