DBA Data[Home] [Help]

APPS.PAY_FR_PAY_FILE dependencies on FND_NUMBER

Line 41: L_opm_id_chr := fnd_number.number_to_canonical(p_opm_id);

37:
38: L_opm_id_chr varchar2(20);
39: L_payers_id varchar2(14);
40: BEGIN
41: L_opm_id_chr := fnd_number.number_to_canonical(p_opm_id);
42: --
43: Select distinct org.organization_id,
44: ori_class.org_information1,
45: decode(ori_class.org_information1,

Line 86: select fnd_number.canonical_to_number(hoi.ORG_INFORMATION1)

82: FUNCTION valid_org (p_estab_id in number) return varchar2 IS
83: L_estab_tbl_ind BINARY_INTEGER;
84: --
85: cursor csr_get_company is
86: select fnd_number.canonical_to_number(hoi.ORG_INFORMATION1)
87: from hr_organization_information hoi
88: where hoi.organization_id = p_estab_id
89: AND hoi.org_information_context = 'FR_ESTAB_INFO';
90: BEGIN