DBA Data[Home] [Help]

APPS.PAY_US_PAYSLIP_SIMULATION_MAIN dependencies on FND_DATE

Line 1649: := fnd_date.date_to_canonical(ld_date_start);

1645: pay_emp_action_arch.lrr_act_tab(ln_index).act_info10
1646: := lv_employee_number ;
1647:
1648: pay_emp_action_arch.lrr_act_tab(ln_index).act_info11
1649: := fnd_date.date_to_canonical(ld_date_start);
1650:
1651: pay_emp_action_arch.lrr_act_tab(ln_index).act_info12
1652: := fnd_date.date_to_canonical(ld_original_date_of_hire);
1653:

Line 1652: := fnd_date.date_to_canonical(ld_original_date_of_hire);

1648: pay_emp_action_arch.lrr_act_tab(ln_index).act_info11
1649: := fnd_date.date_to_canonical(ld_date_start);
1650:
1651: pay_emp_action_arch.lrr_act_tab(ln_index).act_info12
1652: := fnd_date.date_to_canonical(ld_original_date_of_hire);
1653:
1654: pay_emp_action_arch.lrr_act_tab(ln_index).act_info13
1655: := fnd_date.date_to_canonical(ld_adjusted_svc_date);
1656:

Line 1655: := fnd_date.date_to_canonical(ld_adjusted_svc_date);

1651: pay_emp_action_arch.lrr_act_tab(ln_index).act_info12
1652: := fnd_date.date_to_canonical(ld_original_date_of_hire);
1653:
1654: pay_emp_action_arch.lrr_act_tab(ln_index).act_info13
1655: := fnd_date.date_to_canonical(ld_adjusted_svc_date);
1656:
1657: pay_emp_action_arch.lrr_act_tab(ln_index).act_info14
1658: := lv_assignment_number;
1659:

Line 4168: 'pay_payroll_xml_extract_pkg.load_xml(''D'', NULL, ''PAYMENT_DATE'', substr(fnd_date.date_to_canonical(csr_get_sim_arch_info_rec.effective_date),1,10));');

4164: l_cntr_sql,
4165: 'pay_payroll_xml_extract_pkg.load_xml(''D'', NULL, ''END_DATE'', csr_payroll_details_rec.end_date);');
4166: build_sql(sqlstr,
4167: l_cntr_sql,
4168: 'pay_payroll_xml_extract_pkg.load_xml(''D'', NULL, ''PAYMENT_DATE'', substr(fnd_date.date_to_canonical(csr_get_sim_arch_info_rec.effective_date),1,10));');
4169: build_sql(sqlstr,
4170: l_cntr_sql,
4171: 'END LOOP;');
4172: build_sql(sqlstr,