DBA Data[Home] [Help]

APPS.PAY_GB_DEO dependencies on FND_NUMBER

Line 747: fnd_number.number_to_canonical(pact.request_id) request_id,

743: fnd_date.canonical_to_date(SUBSTR(pay_gb_eoy_archive.get_parameter(legislative_parameters,'PAYMENT_TO'),1,10)) payment_to_date,
744: business_group_id,
745: pact.effective_date,
746: pay_gb_eoy_archive.get_parameter(legislative_parameters,'REPORT_FORMAT') report_format,
747: fnd_number.number_to_canonical(pact.request_id) request_id,
748: nvl(upper(substr(ltrim(hoi.org_information3),1,35)),' ') employer_name,
749: nvl(substr(hoi.org_information20,1,12),' ') employer_no
750: from pay_payroll_actions pact,
751: hr_organization_information hoi

Line 785: fnd_number.number_to_canonical(request_id) control_id,

781: l_payroll_name VARCHAR2(80) := '';
782:
783: cursor csr_leg_param is
784: select legislative_parameters para,
785: fnd_number.number_to_canonical(request_id) control_id,
786: report_type,
787: business_group_id,
788: pact.effective_date
789: from pay_payroll_actions pact