DBA Data[Home] [Help]

APPS.PAY_IN_PF_REPORTS dependencies on HR_ORGANIZATION_INFORMATION

Line 1075: -- Gets the data from HR_ORGANIZATION_INFORMATION --

1071: -- It generates the data for the Representative --
1072: -- Details,Filer License Number --
1073: -- Gets the data from PAY_ACTION_INFORMATION --
1074: -- Context : IN_PF_ORG --
1075: -- Gets the data from HR_ORGANIZATION_INFORMATION --
1076: -- Context : PER_IN_COMPANY_FILER_INFO --
1077: -- --
1078: -- --
1079: -- Parameters : --

Line 1107: FROM hr_organization_information

1103:
1104: CURSOR csr_filer_id
1105: IS
1106: SELECT org_information1
1107: FROM hr_organization_information
1108: WHERE org_information2 = p_filer_license_no
1109: AND org_information_context = 'PER_IN_COMPANY_FILER_INFO';
1110:
1111: CURSOR csr_rep_details