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
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,
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
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
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;
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