DBA Data[Home] [Help]

APPS.PAY_FR_PTO_PKG dependencies on HRUSERDT

Line 6201: substr(hruserdt.get_table_value(p_business_group_id, 'FR_CIPDZ', 'CIPDZ',nvl(asg.employment_category,'FR'),p_effective_date),1,1) cipdz_catg

6197: --
6198: Cursor csr_get_time_catg is
6199: Select decode(con.ctr_information12,'HOUR', con.ctr_information13, asg.frequency) frequency,
6200: decode(con.ctr_information12,'HOUR', fnd_number.canonical_to_number(con.ctr_information11), asg.normal_hours) hours,
6201: substr(hruserdt.get_table_value(p_business_group_id, 'FR_CIPDZ', 'CIPDZ',nvl(asg.employment_category,'FR'),p_effective_date),1,1) cipdz_catg
6202: from per_all_assignments_f asg,
6203: per_contracts_f con
6204: where asg.assignment_id = p_assignment_id
6205: and asg.business_group_id = p_business_group_id