APPS.PQP_GB_PSI_BASIC_DATA dependencies on PER_ALL_ASSIGNMENTS_F

Line 22: g_assignment_dtl per_all_assignments_f%rowtype;

18: g_assignment_id NUMBER := NULL; -- IMPORTANT TO KEEP NULL
19:
20: g_person_id NUMBER := NULL;
21: g_person_dtl per_all_people_f%rowtype;
22: g_assignment_dtl per_all_assignments_f%rowtype;
23:
24: g_bank_detail_report_y_n VARCHAR2(2) := NULL;
25: g_bank_details_found VARCHAR2(1) := NULL;
26: g_current_run VARCHAR2(10):= NULL;

Line 94: from per_all_assignments_f paaf

90: ,p_person_id NUMBER
91: )
92: IS
93: select count(distinct assignment_id)
94: from per_all_assignments_f paaf
95: where p_effective_date
96: between paaf.effective_start_date and paaf.effective_end_date
97: and person_id in
98: (select person_id