[Home] [Help]
126: 115.9 23-OCT-2003 ynegoro 3182433 Added get_top_org_id function
127: 115.10 09-APR-04 ynegoro 3545006 Updated get_top_org_id function
128: Added csr_get_max_child_id cursor;
129: 115.11 14-JUL-04 saurgupt 3669973 Modified function get_salary. Modified the query to get freq.
130: from per_assignments_f. Also, add this freq. in the call to fun.
131: hr_us_ff_udfs.Convert_Period_Type.
132: Also, make the file GSCC compliant.
133: 115.12 29-JUL-04 saurgupt 3624095 Modified cursor csr_tax_unit_flag to change the inpur parameter
134: name from tax_unit_id to p_tax_unit_id.
261: pay_element_entry_values_f peev,
262: pay_element_entries_f pee,
263: per_pay_bases ppb,
264: hr_soft_coding_keyflex hscf,
265: per_assignments_f asg,
266: hr_lookups hl
267: Where
268: hl.application_id = 800
269: And hl.lookup_type = 'PAY_BASIS'
325: job.name,
326: ppf.work_telephone
327: From
328: per_people_f ppf,
329: per_assignments_f paf,
330: per_jobs job
331: Where
332: ppf.person_id = p_person_id
333: And ppf.business_group_id + 0 = p_business_group_id