APPS.PAY_PAYMENT_XML_PKG dependencies on FND_DATE

Line 522: substr(fnd_date.date_to_canonical(ppa.effective_date),1,10),

518:
519: CURSOR get_action_details(p_asg_act in number)
520: is
521: select nvl(paa.serial_number,'-9999'),
522: substr(fnd_date.date_to_canonical(ppa.effective_date),1,10),
523: substr(nvl(fnd_date.date_to_canonical(ppa.overriding_dd_date),fnd_date.date_to_canonical(ppa.effective_date)),1,10),
524: ppa.payroll_action_id
525: from pay_assignment_actions paa,pay_payroll_actions ppa
526: where paa.assignment_action_id = p_asg_act

Line 523: substr(nvl(fnd_date.date_to_canonical(ppa.overriding_dd_date),fnd_date.date_to_canonical(ppa.effective_date)),1,10),

519: CURSOR get_action_details(p_asg_act in number)
520: is
521: select nvl(paa.serial_number,'-9999'),
522: substr(fnd_date.date_to_canonical(ppa.effective_date),1,10),
523: substr(nvl(fnd_date.date_to_canonical(ppa.overriding_dd_date),fnd_date.date_to_canonical(ppa.effective_date)),1,10),
524: ppa.payroll_action_id
525: from pay_assignment_actions paa,pay_payroll_actions ppa
526: where paa.assignment_action_id = p_asg_act
527: and paa.payroll_action_id=ppa.payroll_action_id;

Line 1009: get_ppm_segment_name(l_per_pay_method,fnd_date.canonical_to_date(l_chq_effective_date),g_per_info(cntr));

1005:
1006: load_xml('CS','PERSONAL_PAYMENT_METHOD_INFO','');
1007: FOR cntr IN 1..30 LOOP
1008: IF g_per_info(cntr) IS NOT NULL THEN
1009: get_ppm_segment_name(l_per_pay_method,fnd_date.canonical_to_date(l_chq_effective_date),g_per_info(cntr));
1010: load_xml('D','INFORMATION'||cntr ,g_per_info(cntr));
1011: END IF;
1012: END LOOP;
1013: load_xml('CE','PERSONAL_PAYMENT_METHOD_INFO','');

Line 1027: get_opm_segment_name(l_det_org_pay_method,fnd_date.canonical_to_date(l_chq_effective_date),g_opm_info(cntr));

1023:
1024: load_xml('CS','ORG_PAYMENT_METHOD_INFO','');
1025: FOR cntr IN 1..20 LOOP
1026: IF g_opm_info(cntr) IS NOT NULL THEN
1027: get_opm_segment_name(l_det_org_pay_method,fnd_date.canonical_to_date(l_chq_effective_date),g_opm_info(cntr));
1028: load_xml('D','INFORMATION'||cntr ,g_opm_info(cntr));
1029: END IF;
1030: END LOOP;
1031: load_xml('CE','ORG_PAYMENT_METHOD_INFO','');