APPS.PQH_SS_UTILITY dependencies on HR_API_TRANSACTIONS

Line 457: FROM hr_api_transactions t, hr_api_transaction_steps ts

453: 'HR_TERMINATION_SS.PROCESS_API' );
454: --
455: CURSOR cur_pnd IS
456: SELECT 'X'
457: FROM hr_api_transactions t, hr_api_transaction_steps ts
458: WHERE t.transaction_id = ts.transaction_id
459: AND ts.item_type = p_itemType
460: AND ts.update_person_id = p_personId
461: AND t.status in ('Y','YS','RO','ROS') -- not considering C, RI, RIS as they are with init

Line 591: FROM per_all_assignments_f af, hr_api_transactions hat

587: ,p_dateTrack_mode IN VARCHAR2 ) IS
588: --
589: CURSOR cur_asgn IS
590: SELECT null
591: FROM per_all_assignments_f af, hr_api_transactions hat
592: WHERE af.assignment_id = hat.assignment_id
593: AND af.effective_start_date = hat.transaction_effective_date
594: AND hat.transaction_id = p_txnId;
595: --

Line 820: FROM hr_api_transactions

816: AND name = p_param_name;
817: --
818: CURSOR cur_txnStep (c_txnId NUMBER ) IS
819: SELECT item_type,item_key
820: FROM hr_api_transactions
821: WHERE transaction_id = c_txnId;
822: --
823: CURSOR chk_ex_emp(l_person_id in number, l_effective_date in Date) is
824: select ppt.SYSTEM_PERSON_TYPE from per_all_people_f paf, per_person_types ppt where person_id = l_person_id