APPS.RCV_HXT_GRP dependencies on PER_ALL_ASSIGNMENTS_F

Line 142: ( person_id PER_ALL_ASSIGNMENTS_F.person_id%TYPE

138:
139: -- The PO information is new to 11.5.10 so do not introduce
140: -- compile-time dependency on those fields
141: TYPE per_all_assignments_cr IS RECORD
142: ( person_id PER_ALL_ASSIGNMENTS_F.person_id%TYPE
143: , po_line_id PO_LINES_ALL.po_line_id%TYPE
144: , effective_start_date PER_ALL_ASSIGNMENTS_F.effective_start_date%TYPE
145: , effective_end_date PER_ALL_ASSIGNMENTS_F.effective_end_date%TYPE
146: );

Line 144: , effective_start_date PER_ALL_ASSIGNMENTS_F.effective_start_date%TYPE

140: -- compile-time dependency on those fields
141: TYPE per_all_assignments_cr IS RECORD
142: ( person_id PER_ALL_ASSIGNMENTS_F.person_id%TYPE
143: , po_line_id PO_LINES_ALL.po_line_id%TYPE
144: , effective_start_date PER_ALL_ASSIGNMENTS_F.effective_start_date%TYPE
145: , effective_end_date PER_ALL_ASSIGNMENTS_F.effective_end_date%TYPE
146: );
147:
148: TYPE rcv_transactions_cr IS RECORD

Line 145: , effective_end_date PER_ALL_ASSIGNMENTS_F.effective_end_date%TYPE

141: TYPE per_all_assignments_cr IS RECORD
142: ( person_id PER_ALL_ASSIGNMENTS_F.person_id%TYPE
143: , po_line_id PO_LINES_ALL.po_line_id%TYPE
144: , effective_start_date PER_ALL_ASSIGNMENTS_F.effective_start_date%TYPE
145: , effective_end_date PER_ALL_ASSIGNMENTS_F.effective_end_date%TYPE
146: );
147:
148: TYPE rcv_transactions_cr IS RECORD
149: ( receive_transaction_id RCV_TRANSACTIONS.transaction_id%TYPE

Line 861: , p_person_id IN PER_ALL_ASSIGNMENTS_F.person_id%TYPE

857: -- Gets assignment for this PO/person effective on a particular date
858: -- Throws a NO DATA FOUND if no such assignment exists
859: FUNCTION get_assignment
860: ( p_po_line_id IN PO_LINES_ALL.po_line_id%TYPE
861: , p_person_id IN PER_ALL_ASSIGNMENTS_F.person_id%TYPE
862: , p_effective_date IN DATE
863: ) RETURN per_all_assignments_cr IS
864: l_sql VARCHAR2(1500);
865: BEGIN

Line 884: FROM per_all_assignments_f paaf

880: -- The po info in this table is new in 11.5.10
881: -- so we use dynamic sql to avoid compile-time
882: -- dependencies to the new fields
883: l_sql :=' SELECT effective_start_date , effective_end_date
884: FROM per_all_assignments_f paaf
885: WHERE paaf.po_line_id = :po_line_id
886: AND paaf.person_id = :person_id
887: AND Trunc(:effective_date)
888: BETWEEN Trunc(paaf.effective_start_date)

Line 892: FROM per_all_assignments_f paaf,

888: BETWEEN Trunc(paaf.effective_start_date)
889: AND Trunc(paaf.effective_end_date)
890: UNION
891: SELECT effective_start_date , effective_end_date
892: FROM per_all_assignments_f paaf,
893: po_cwk_associations pca,
894: po_headers_all ph,
895: po_lines_all pl
896: WHERE pca.po_line_id = :po_line_id