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

Line 252: l_bg_name per_business_groups.name%TYPE;

248: l_leg_param pay_payroll_actions.legislative_parameters%TYPE ;
249: l_prd_end_date_ch VARCHAR2(20);
250: l_prd_end_date_fmt VARCHAR2(20);
251: l_payroll_action_id number;
252: l_bg_name per_business_groups.name%TYPE;
253: l_bus_group_id per_business_groups.business_group_id%TYPE;
254: l_session_date fnd_sessions.effective_date%TYPE; /* Bug 9612150 */
255:
256: CURSOR get_parameters(c_payroll_action_id pay_payroll_actions.payroll_action_id%TYPE)

Line 253: l_bus_group_id per_business_groups.business_group_id%TYPE;

249: l_prd_end_date_ch VARCHAR2(20);
250: l_prd_end_date_fmt VARCHAR2(20);
251: l_payroll_action_id number;
252: l_bg_name per_business_groups.name%TYPE;
253: l_bus_group_id per_business_groups.business_group_id%TYPE;
254: l_session_date fnd_sessions.effective_date%TYPE; /* Bug 9612150 */
255:
256: CURSOR get_parameters(c_payroll_action_id pay_payroll_actions.payroll_action_id%TYPE)
257: IS

Line 276: FROM per_business_groups

272:
273: CURSOR get_business_group(c_business_group_id hr_organization_units.business_group_id%TYPE)
274: IS
275: SELECT name
276: FROM per_business_groups
277: WHERE business_group_id = c_business_group_id
278: AND legislation_code = 'NZ';
279:
280: /* 9612150 - Added cursor to fetch the session date.If effective date parameter of