DBA Data[Home] [Help]

APPS.PAY_CA_T4AEOY_ARCHIVE dependencies on HR_LOCATIONS_ALL

Line 1244: hr_locations_all hl1, /* trans location */

1240: hr_organization_information hoi2, /* Transmitter GRE to check
1241: 'Fed Magnetic Reporting' */
1242: hr_organization_information hoi3, /* Transmitter GRE to check
1243: 'Employer Identification' */
1244: hr_locations_all hl1, /* trans location */
1245: hr_all_organization_units ou2, /* GRE Org */
1246: hr_organization_information hoi4, /* GRE to check GRE/Legal
1247: Classification is enabled */
1248: hr_organization_information hoi6, /* GRE to check

Line 1250: hr_locations_all hl2, /* GRE location */

1246: hr_organization_information hoi4, /* GRE to check GRE/Legal
1247: Classification is enabled */
1248: hr_organization_information hoi6, /* GRE to check
1249: 'Employer Identification'*/
1250: hr_locations_all hl2, /* GRE location */
1251: per_business_groups bg
1252: where bg.business_group_id = ou1.business_group_id
1253: and bg.legislation_code = 'CA'
1254: and ou1.organization_id = p_transmitter_gre_id