DBA Data[Home] [Help]

APPS.PAY_USER_COLUMN_INSTA_MATRIX dependencies on HR_ORGANIZATION_UNITS

Line 648: cursor csr_get_user_column_id (c_business_group hr_organization_units.name%type

644: l_user_column_id pay_user_columns.user_column_id%type;
645: l_user_key_id number;
646:
647:
648: cursor csr_get_user_column_id (c_business_group hr_organization_units.name%type
649: ,c_user_column_name pay_user_columns.user_column_name%type
650: ,c_user_key_value varchar2
651: ,c_user_table_name pay_user_tables.user_table_name%type)
652: is

Line 724: c_business_group hr_organization_units.name%type

720: l_user_row_id pay_user_rows_f.user_row_id%type;
721: l_user_key_id number;
722:
723: cursor csr_get_user_row_id(
724: c_business_group hr_organization_units.name%type
725: ,c_user_row_name pay_user_rows_f.row_low_range_or_name%type
726: ,c_effective_date date
727: ,c_user_key_value varchar2
728: ,c_user_table_name pay_user_tables.user_table_name%type)

Line 806: ,c_business_group hr_organization_units.name%type

802: l_user_key_value varchar2(240);
803: l_user_key_id number;
804:
805: cursor csr_get_user_table_id( c_user_key_value varchar2
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