eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

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 870: , p_person_id IN PER_ALL_ASSIGNMENTS_F.person_id%TYPE

866: -- Gets assignment for this PO/person effective on a particular date
867: -- Throws a NO DATA FOUND if no such assignment exists
868: FUNCTION get_assignment
869: ( p_po_line_id IN PO_LINES_ALL.po_line_id%TYPE
870: , p_person_id IN PER_ALL_ASSIGNMENTS_F.person_id%TYPE
871: , p_effective_date IN DATE
872: ) RETURN per_all_assignments_cr IS
873: l_sql VARCHAR2(1500);
874: BEGIN

Line 892: FROM per_all_assignments_f paaf

888: -- The po info in this table is new in 11.5.10
889: -- so we use dynamic sql to avoid compile-time
890: -- dependencies to the new fields
891: l_sql :=' SELECT effective_start_date , effective_end_date
892: FROM per_all_assignments_f paaf
893: WHERE paaf.po_line_id = :po_line_id
894: AND paaf.person_id = :person_id
895: AND Trunc(:effective_date)
896: BETWEEN Trunc(paaf.effective_start_date)

Line 900: FROM per_all_assignments_f paaf

896: BETWEEN Trunc(paaf.effective_start_date)
897: AND Trunc(paaf.effective_end_date)
898: UNION
899: SELECT effective_start_date , effective_end_date
900: FROM per_all_assignments_f paaf
901: , po_cwk_associations pca
902: , po_headers_all ph
903: , po_lines_all pl
904: WHERE pca.po_line_id = :po_line_id