APPS.PAY_USER_COLUMN_INSTA_MATRIX dependencies on PER_BUSINESS_GROUPS

Line 161: from per_business_groups

157:
158: cursor csr_get_business_group_name (c_business_group_id number)
159: is
160: select name
161: from per_business_groups
162: where business_group_id = c_business_group_id;
163:
164: begin
165: open csr_get_user_table_id(p_user_table_name,p_business_group_id);

Line 307: cursor csr_get_business_group_id (c_business_group_name per_business_groups.name%type)

303:
304: counter number;
305: cur number;
306:
307: cursor csr_get_business_group_id (c_business_group_name per_business_groups.name%type)
308: is
309: select business_group_id
310: from per_business_groups
311: where name = c_business_group_name;

Line 310: from per_business_groups

306:
307: cursor csr_get_business_group_id (c_business_group_name per_business_groups.name%type)
308: is
309: select business_group_id
310: from per_business_groups
311: where name = c_business_group_name;
312:
313:
314: begin

Line 655: per_business_groups pbg,

651: ,c_user_table_name pay_user_tables.user_table_name%type)
652: is
653: select puc.user_column_id
654: from pay_user_columns puc,
655: per_business_groups pbg,
656: pay_user_tables put
657: where (put.business_group_id is null or put.business_group_id = pbg.business_group_id)
658: and (put.legislation_code is null or put.legislation_code= hr_api.return_legislation_code(pbg.business_group_id))
659: and pbg.name = c_business_group

Line 732: per_business_groups pbg,

728: ,c_user_table_name pay_user_tables.user_table_name%type)
729: is
730: select pur.user_row_id
731: from pay_user_rows_f pur,
732: per_business_groups pbg,
733: pay_user_tables put
734: where (put.business_group_id is null or put.business_group_id= pbg.business_group_id)
735: and (put.legislation_code is null or put.legislation_code = hr_api.return_legislation_code(pbg.business_group_id))
736: and pbg.name = c_business_group

Line 810: from pay_user_tables put,per_business_groups pbg

806: ,c_business_group hr_organization_units.name%type
807: ,c_user_table_name pay_user_tables.user_table_name%type)
808: is
809: select put.user_table_id
810: from pay_user_tables put,per_business_groups pbg
811: where user_table_name = c_user_table_name
812: and pbg.name = c_business_group
813: and (put.business_group_id is null or put.business_group_id = pbg.business_group_id)
814: and (put.legislation_code is null or put.legislation_code= hr_api.return_legislation_code(pbg.business_group_id));

Line 900: from per_business_groups

896:
897: cursor csr_get_business_group_name(c_business_group_id number)
898: is
899: select name
900: from per_business_groups
901: where business_group_id = c_business_group_id;
902:
903:
904: