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.PAY_US_GET_ITEM_DATA_PKG dependencies on PER_ALL_ASSIGNMENTS_F

Line 186: CURSOR get_position(c_person_id PER_ALL_ASSIGNMENTS_F.PERSON_ID%TYPE,

182:
183: -- Another Cursor to fetch the Position Title for MD (Bug 9571133)
184:
185:
186: CURSOR get_position(c_person_id PER_ALL_ASSIGNMENTS_F.PERSON_ID%TYPE,
187: c_date_earned date)
188: IS
189: SELECT hpf.name
190: FROM per_all_assignments_f paf,

Line 190: FROM per_all_assignments_f paf,

186: CURSOR get_position(c_person_id PER_ALL_ASSIGNMENTS_F.PERSON_ID%TYPE,
187: c_date_earned date)
188: IS
189: SELECT hpf.name
190: FROM per_all_assignments_f paf,
191: hr_all_positions_f hpf
192: WHERE paf.position_id = hpf.position_id
193: AND paf.person_id = c_person_id
194: AND c_date_earned BETWEEN paf.effective_start_date

Line 760: (c_assignment_id per_all_assignments_f.assignment_id%type,

756: --
757: -- This cursor would be used for W2, SQWL and 1099R mag
758: --
759: CURSOR get_mmref_person_name
760: (c_assignment_id per_all_assignments_f.assignment_id%type,
761: c_effective_date date)
762: IS
763: SELECT ppf.full_name ,
764: ppf.employee_number

Line 765: from per_all_assignments_f assign

761: c_effective_date date)
762: IS
763: SELECT ppf.full_name ,
764: ppf.employee_number
765: from per_all_assignments_f assign
766: , per_all_people_f ppf
767: where ASSIGN.assignment_id = c_assignment_id
768: and c_effective_date BETWEEN ASSIGN.effective_start_date
769: AND ASSIGN.effective_end_date

Line 779: (c_assignment_id per_all_assignments_f.assignment_id%type,

775: --
776: -- This cursor would be used for W2, SQWL, 1099R mag
777: --
778: CURSOR get_mmref_name_address
779: (c_assignment_id per_all_assignments_f.assignment_id%type,
780: c_effective_date date)
781: IS
782: SELECT ppf.full_name ,
783: ppf.employee_number ,

Line 797: from per_all_assignments_f assign

793: fttl.territory_short_name,
794: addr.region_1 ,
795: addr.region_2 ,
796: 'Y' valid_address
797: from per_all_assignments_f assign
798: , per_addresses addr
799: , per_all_people_f ppf
800: , fnd_territories_tl fttl
801: , fnd_territories ftt

Line 825: (c_assignment_id per_all_assignments_f.assignment_id%type)

821: -- for the given effective_date. This cursor will fetch employee current
822: -- primary address
823: --
824: CURSOR get_mmref_name_address_eod
825: (c_assignment_id per_all_assignments_f.assignment_id%type)
826: IS
827: SELECT ppf.full_name ,
828: ppf.employee_number ,
829: addr.address_line1 ,

Line 842: FROM per_all_assignments_f ASSIGN

838: fttl.territory_short_name,
839: addr.region_1 ,
840: addr.region_2 ,
841: 'Y' valid_address
842: FROM per_all_assignments_f ASSIGN
843: , per_addresses ADDR
844: , per_all_people_f PPF
845: , fnd_territories_tl fttl
846: , fnd_territories ftt