DBA Data[Home] [Help]

APPS.PAY_AE_GENERAL dependencies on FND_DATE

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

508: BEGIN
509: l_expiry_status := 'N';
510: BEGIN
511:
512: SELECT cont.type, fnd_date.canonical_to_date(cont.ctr_information2)
513: INTO l_contract, l_expiry_date
514: FROM per_contracts_f cont
515: ,per_all_assignments_f asg
516: WHERE asg.assignment_id = p_assignment_id

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

727: close csr_get_formula_id;
728: l_inputs(1).name := 'ASSIGNMENT_ID';
729: l_inputs(1).value := p_assignment_id;
730: l_inputs(2).name := 'DATE_EARNED';
731: l_inputs(2).value := fnd_date.date_to_canonical(p_date_earned);
732: l_inputs(3).name := 'BUSINESS_GROUP_ID';
733: l_inputs(3).value := p_business_group_id;
734: l_inputs(4).name := 'PAYROLL_ID';
735: l_inputs(4).value := p_payroll_id;

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

813: close csr_get_formula_id;
814: l_inputs(1).name := 'ASSIGNMENT_ID';
815: l_inputs(1).value := p_assignment_id;
816: l_inputs(2).name := 'DATE_EARNED';
817: l_inputs(2).value := fnd_date.date_to_canonical(p_date_earned);
818: l_inputs(3).name := 'BUSINESS_GROUP_ID';
819: l_inputs(3).value := p_business_group_id;
820: l_inputs(4).name := 'PAYROLL_ID';
821: l_inputs(4).value := p_payroll_id;