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_PYNZREC_XMLP_PKG dependencies on HR_LOOKUPS

Line 33: hr_lookups fcl

29: to_char(ppa.display_run_number) || ')' display
30: from pay_all_payrolls_f pap,
31: per_time_periods ptp,
32: pay_payroll_actions ppa,
33: hr_lookups fcl
34: where ppa.payroll_action_id = c_payroll_action_id
35: and pap.payroll_id = ppa.payroll_id
36: and ppa.payroll_id = ptp.payroll_id
37: and ptp.end_date = ppa.date_earned

Line 91: v_lookup_type hr_lookups.lookup_type%type := 'NZ_REC_REPORT_SORT_BY';

87: end;
88:
89: function CF_sort_order_displayFormula return VARCHAR2 is
90:
91: v_lookup_type hr_lookups.lookup_type%type := 'NZ_REC_REPORT_SORT_BY';
92: v_meaning hr_lookups.meaning%type := '';
93:
94: cursor lookup_meaning
95: (c_lookup_type hr_lookups.lookup_type%type,

Line 92: v_meaning hr_lookups.meaning%type := '';

88:
89: function CF_sort_order_displayFormula return VARCHAR2 is
90:
91: v_lookup_type hr_lookups.lookup_type%type := 'NZ_REC_REPORT_SORT_BY';
92: v_meaning hr_lookups.meaning%type := '';
93:
94: cursor lookup_meaning
95: (c_lookup_type hr_lookups.lookup_type%type,
96: c_lookup_code hr_lookups.lookup_code%type) is

Line 95: (c_lookup_type hr_lookups.lookup_type%type,

91: v_lookup_type hr_lookups.lookup_type%type := 'NZ_REC_REPORT_SORT_BY';
92: v_meaning hr_lookups.meaning%type := '';
93:
94: cursor lookup_meaning
95: (c_lookup_type hr_lookups.lookup_type%type,
96: c_lookup_code hr_lookups.lookup_code%type) is
97: select meaning
98: from hr_lookups
99: where lookup_type = c_lookup_type

Line 96: c_lookup_code hr_lookups.lookup_code%type) is

92: v_meaning hr_lookups.meaning%type := '';
93:
94: cursor lookup_meaning
95: (c_lookup_type hr_lookups.lookup_type%type,
96: c_lookup_code hr_lookups.lookup_code%type) is
97: select meaning
98: from hr_lookups
99: where lookup_type = c_lookup_type
100: and lookup_code = c_lookup_code;

Line 98: from hr_lookups

94: cursor lookup_meaning
95: (c_lookup_type hr_lookups.lookup_type%type,
96: c_lookup_code hr_lookups.lookup_code%type) is
97: select meaning
98: from hr_lookups
99: where lookup_type = c_lookup_type
100: and lookup_code = c_lookup_code;
101:
102: begin