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_HK_IR56_ARCHIVE dependencies on FND_TERRITORIES_TL

Line 111: -- fnd_territories_vl replaced with fnd_territories_tl table and a

107: -- 28 Aug 2003 srrajago 3059915 # In the cursor 'process_assignments', few joins with effective_date,
108: -- reporting_year and business_group_id included.Few joins with
109: -- pay_core_utils removed.
110: -- # In the cursors 'ir56_Spouse_info' and 'ir56_Employee_info',view
111: -- fnd_territories_vl replaced with fnd_territories_tl table and a
112: -- join with language also included.
113: -- # In the procedure 'Archive_Excep_Error_dtls', cursor 'ir56_employer_info'
114: -- modified.Table per_assignments_f and its related joins removed.
115: -- Cursor 'ir56_Employee_info' also modified.A join with period_of_service_id

Line 443: fnd_territories_tl ftv, /* Bug No : 3059915 */

439: pcr.contact_type contact_type, -- used in spouse cursor
440: pcr.date_start date_start
441: FROM per_people_f papf,
442: per_assignments_f paaf,
443: fnd_territories_tl ftv, /* Bug No : 3059915 */
444: per_contact_relationships pcr,
445: per_addresses pad,
446: per_assignment_extra_info paei,
447: per_periods_of_service pps,

Line 503: fnd_territories_tl ftv /* Bug No : 3059915 */

499: papf_spouse.per_information1
500: ||DECODE(papf_spouse.per_information2,NULL, NULL, ' '
501: || ftv.territory_short_name) passport_info
502: FROM per_people_f papf_spouse,
503: fnd_territories_tl ftv /* Bug No : 3059915 */
504: WHERE papf_spouse.person_id = c_person_id
505: AND papf_spouse.business_group_id = p_business_group_id
506: AND papf_spouse.per_information2 = ftv.territory_code(+)
507: AND ftv.language(+) = userenv('LANG') /* Bug No : 3059915 */