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_GB_REP dependencies on PER_BUSINESS_GROUPS

Line 19: from per_business_groups pbg,

15: select distinct
16: pbg.name,
17: fnd_date.canonical_to_date(p_effective_date),
18: decode(p_payroll_id,null, ' ',papf.payroll_id, papf.payroll_name)
19: from per_business_groups pbg,
20: pay_all_payrolls_f papf
21: where pbg.business_group_id = p_business_group_id
22: and pbg.business_group_id = papf.business_group_id
23: and papf.payroll_id = nvl(to_number(p_payroll_id),papf.payroll_id)

Line 107: from per_business_groups pbg,

103: c_effective_date VARCHAR2) is
104: select pbg.name,
105: fnd_date.canonical_to_date(c_effective_date),
106: decode(c_payroll_id,null, ' ',papf.payroll_id, papf.payroll_name)
107: from per_business_groups pbg,
108: pay_all_payrolls_f papf
109: where pbg.business_group_id = c_business_group_id
110: and pbg.business_group_id = papf.business_group_id
111: and papf.payroll_id = nvl(to_number(c_payroll_id),papf.payroll_id)

Line 121: from per_business_groups pbg,

117: c_effective_date DATE) is
118: select distinct
119: papf.payroll_id,
120: papf.payroll_name
121: from per_business_groups pbg,
122: pay_all_payrolls_f papf
123: where pbg.business_group_id = c_business_group_id
124: and pbg.business_group_id = papf.business_group_id
125: and papf.payroll_id = nvl(to_number(c_payroll_id),papf.payroll_id)