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 102: from per_all_assignments_f paaf

98: ,p_person_id NUMBER
99: )
100: IS
101: select count(distinct assignment_id)
102: from per_all_assignments_f paaf
103: where p_effective_date
104: between paaf.effective_start_date and paaf.effective_end_date
105: and assignment_type <> 'A' --Added for bug 7693193
106: and person_id in