DBA Data[Home] [Help]

APPS.PAY_AE_GENERAL dependencies on FND_DATE

Line 446: SELECT cont.type, fnd_date.canonical_to_date(cont.ctr_information2)

442: BEGIN
443: l_expiry_status := 'N';
444: BEGIN
445:
446: SELECT cont.type, fnd_date.canonical_to_date(cont.ctr_information2)
447: INTO l_contract, l_expiry_date
448: FROM per_contracts_f cont
449: ,per_all_assignments_f asg
450: WHERE asg.assignment_id = p_assignment_id

Line 665: l_inputs(2).value := fnd_date.date_to_canonical(p_date_earned);

661: close csr_get_formula_id;
662: l_inputs(1).name := 'ASSIGNMENT_ID';
663: l_inputs(1).value := p_assignment_id;
664: l_inputs(2).name := 'DATE_EARNED';
665: l_inputs(2).value := fnd_date.date_to_canonical(p_date_earned);
666: l_inputs(3).name := 'BUSINESS_GROUP_ID';
667: l_inputs(3).value := p_business_group_id;
668: l_inputs(4).name := 'PAYROLL_ID';
669: l_inputs(4).value := p_payroll_id;

Line 751: l_inputs(2).value := fnd_date.date_to_canonical(p_date_earned);

747: close csr_get_formula_id;
748: l_inputs(1).name := 'ASSIGNMENT_ID';
749: l_inputs(1).value := p_assignment_id;
750: l_inputs(2).name := 'DATE_EARNED';
751: l_inputs(2).value := fnd_date.date_to_canonical(p_date_earned);
752: l_inputs(3).name := 'BUSINESS_GROUP_ID';
753: l_inputs(3).value := p_business_group_id;
754: l_inputs(4).name := 'PAYROLL_ID';
755: l_inputs(4).value := p_payroll_id;