APPS.HRI_OPL_PER_PERSON dependencies on PO_AGENTS

Line 613: ,po_agents poa

609: ,per.person_id
610: ,NVL(per.marital_status,'NA_EDW')
611: ,NVL(per.sex,'NA_EDW')
612: FROM per_all_people_f per
613: ,po_agents poa
614: WHERE per.person_id = poa.agent_id(+)
615: AND TRUNC(sysdate) between per.effective_start_date and per.effective_end_date
616: AND NOT EXISTS (SELECT 'x'
617: FROM hri_cs_per_person_ct tbl

Line 647: FROM hri_cs_per_person_ct tbl, po_agents poa

643: )
644: then 'Y'
645: else 'N'
646: end buyer_flag
647: FROM hri_cs_per_person_ct tbl, po_agents poa
648: WHERE tbl.per_person_pk = poa.agent_id(+)
649: )ct
650: WHERE ct.buyer_flag <> ct.collected_flag
651: );

Line 834: po_agents poa

830: ,per.person_id
831: ,NVL(per.marital_status,'NA_EDW')
832: ,NVL(per.sex,'NA_EDW')
833: FROM per_all_people_f per,
834: po_agents poa
835: WHERE TRUNC(sysdate) between per.effective_start_date and per.effective_end_date
836: AND per.person_id = poa.agent_id(+);
837:
838: --