DBA Data[Home] [Help]

APPS.PAY_NO_SELF_CERTIFICATION_RPT dependencies on FND_DATE

Line 47: CURSOR csr_legal_employer is select o.name,fnd_date.canonical_to_date(pai.action_information4) from

43: l_legal_employer_id number;
44: l_legal_employer HR_ORGANIZATION_UNITS.name%type;
45: l_eff_date date;
46:
47: CURSOR csr_legal_employer is select o.name,fnd_date.canonical_to_date(pai.action_information4) from
48: HR_ORGANIZATION_UNITS o,
49: HR_ORGANIZATION_INFORMATION hoi1,
50: pay_action_information pai
51: where pai.action_context_id = l_payroll_action_id