DBA Data[Home] [Help]

APPS.PQH_RBC_LOAD_OBJECTS dependencies on PER_BUSINESS_GROUPS_PERF

Line 1231: (select legislation_code from per_business_groups_perf where business_group_id = l_business_group_id)

1227: select element_type_id from pay_element_types_f
1228: where element_name = p_element_type_name
1229: and l_effective_date between effective_start_date and effective_end_date
1230: and (business_group_id = l_business_group_id OR (legislation_code in
1231: (select legislation_code from per_business_groups_perf where business_group_id = l_business_group_id)
1232: and business_group_id is null));
1233: --
1234:
1235: Cursor csr_cre(crd_id in number,ele_id in number)is

Line 1406: (select legislation_code from per_business_groups_perf where business_group_id = l_business_group_id)

1402: select element_type_id from pay_element_types_f
1403: where element_name = p_element_type_name
1404: and l_effective_date between effective_start_date and effective_end_date
1405: and (business_group_id = l_business_group_id OR (legislation_code in
1406: (select legislation_code from per_business_groups_perf where business_group_id = l_business_group_id)
1407: and business_group_id is null));
1408: --
1409:
1410: Cursor csr_inp is

Line 1416: (select legislation_code from per_business_groups_perf where business_group_id = l_business_group_id)

1412: where name = p_input_value_name
1413: and element_type_id = l_element_type_id
1414: and l_effective_date between effective_start_date and effective_end_date
1415: and (business_group_id = l_business_group_id OR (legislation_code in
1416: (select legislation_code from per_business_groups_perf where business_group_id = l_business_group_id)
1417: and business_group_id is null));
1418: --
1419:
1420: Cursor csr_cre(crd_id in number,ele_id in number,inp_id in number)is

Line 1565: (select legislation_code from per_business_groups_perf where business_group_id = l_business_group_id)

1561: select element_type_id from pay_element_types_f
1562: where element_name = p_element_type_name
1563: and l_effective_date between effective_start_date and effective_end_date
1564: and (business_group_id = l_business_group_id OR (legislation_code in
1565: (select legislation_code from per_business_groups_perf where business_group_id = l_business_group_id)
1566: and business_group_id is null));
1567: --
1568:
1569: