DBA Data[Home] [Help]

APPS.PSP_PSPENASG_XMLP_PKG dependencies on PER_ALL_ASSIGNMENTS_F

Line 54: per_all_assignments_f paf

50:
51: CURSOR c_org_acct_del IS
52: SELECT hou.name
53: FROM hr_all_organization_units hou,
54: per_all_assignments_f paf
55: WHERE paf.assignment_id =assignment_id
56: AND paf.organization_id= hou.organization_id
57: AND sysdate between paf.effective_start_date and paf.effective_end_date;
58: