[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.
253: pay_element_entry_values_f peev,
254: pay_element_entries_f pee,
255: per_pay_bases ppb,
256: hr_soft_coding_keyflex hscf,
257: per_assignments_f asg,
258: hr_lookups hl
259: Where
260: hl.application_id = 800
261: And hl.lookup_type = 'PAY_BASIS'
317: job.name,
318: ppf.work_telephone
319: From
320: per_people_f ppf,
321: per_assignments_f paf,
322: per_jobs job
323: Where
324: ppf.person_id = p_person_id
325: And ppf.business_group_id + 0 = p_business_group_id