DBA Data[Home] [Help]

APPS.PER_DIF_STMT_REPORT dependencies on HRUSERDT

Line 393: substr(hruserdt.get_table_value(p_business_group_id, 'FR_CIPDZ', 'CIPDZ',nvl(asg.employment_category,'FR'),p_date_from),1,1) asg_catg,

389: -- statement period
390: -- and change in employment category
391: Cursor csr_dif_acc_periods is
392: select asg.effective_start_date start_date,
393: substr(hruserdt.get_table_value(p_business_group_id, 'FR_CIPDZ', 'CIPDZ',nvl(asg.employment_category,'FR'),p_date_from),1,1) asg_catg,
394: asg.payroll_id payroll_id,
395: decode(ctr.ctr_information12, 'HOUR', fnd_number.canonical_to_number(ctr.ctr_information11), asg.normal_hours) wkg_hours
396: from per_all_assignments_f asg,
397: per_contracts_f ctr