DBA Data[Home] [Help]

APPS.PQH_WKS_ERROR_CHK dependencies on PQH_POSITION_TRANSACTIONS

Line 52: cursor c5 is select business_group_id from pqh_position_transactions

48: cursor c3 is select business_group_id from per_jobs
49: where job_id = l_job_id;
50: cursor c4 is select business_group_id from per_grades
51: where grade_id = l_grade_id;
52: cursor c5 is select business_group_id from pqh_position_transactions
53: where position_transaction_id = l_position_transaction_id;
54: begin
55: open c1;
56: fetch c1 into l_position_id,l_organization_id,l_job_id,l_grade_id,l_position_transaction_id;

Line 2134: FROM pqh_position_transactions

2130: WHERE worksheet_detail_id = p_worksheet_detail_id ;
2131:
2132: CURSOR csr_ptx_name(p_position_transaction_id IN number) IS
2133: SELECT name
2134: FROM pqh_position_transactions
2135: WHERE position_transaction_id = p_position_transaction_id;
2136:
2137: BEGIN
2138: