eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PER_UPLOAD_USER_TABLE dependencies on PAY_USER_COLUMNS

Line 162: pay_user_columns puc,

158: puci.effective_start_date,
159: puci.value
160: from pay_user_column_instances_f puci,
161: pay_user_rows_f pur,
162: pay_user_columns puc,
163: pay_user_tables put
164: where put.user_table_name=p_user_table_name
165: and put.legislation_code=g_legislation_code
166: and put.business_group_id is null

Line 220: pay_user_columns puc,

216: -1,
217: 1,
218: sysdate
219: from pay_user_rows_f pur,
220: pay_user_columns puc,
221: pay_user_tables put
222: where put.user_table_name=p_user_table_name
223: and put.legislation_code=g_legislation_code
224: and put.business_group_id is NULL

Line 704: l_user_column_id_loc pay_user_columns.user_column_id%type;

700: procedure populate_locality_county_lov
701: (p_business_group_id IN NUMBER)
702: IS
703: l_user_table_id pay_user_tables.user_table_id%type;
704: l_user_column_id_loc pay_user_columns.user_column_id%type;
705: l_user_column_id_pin pay_user_columns.user_column_id%type;
706: l_user_column_id_con pay_user_columns.user_column_id%type;
707: TYPE tb_locality IS TABLE OF VARCHAR2(80) INDEX BY BINARY_INTEGER;
708: TYPE tb_county IS TABLE OF VARCHAR2(80) INDEX BY BINARY_INTEGER;

Line 705: l_user_column_id_pin pay_user_columns.user_column_id%type;

701: (p_business_group_id IN NUMBER)
702: IS
703: l_user_table_id pay_user_tables.user_table_id%type;
704: l_user_column_id_loc pay_user_columns.user_column_id%type;
705: l_user_column_id_pin pay_user_columns.user_column_id%type;
706: l_user_column_id_con pay_user_columns.user_column_id%type;
707: TYPE tb_locality IS TABLE OF VARCHAR2(80) INDEX BY BINARY_INTEGER;
708: TYPE tb_county IS TABLE OF VARCHAR2(80) INDEX BY BINARY_INTEGER;
709: TYPE tb_postalcode IS TABLE OF VARCHAR2(80) INDEX BY BINARY_INTEGER;

Line 706: l_user_column_id_con pay_user_columns.user_column_id%type;

702: IS
703: l_user_table_id pay_user_tables.user_table_id%type;
704: l_user_column_id_loc pay_user_columns.user_column_id%type;
705: l_user_column_id_pin pay_user_columns.user_column_id%type;
706: l_user_column_id_con pay_user_columns.user_column_id%type;
707: TYPE tb_locality IS TABLE OF VARCHAR2(80) INDEX BY BINARY_INTEGER;
708: TYPE tb_county IS TABLE OF VARCHAR2(80) INDEX BY BINARY_INTEGER;
709: TYPE tb_postalcode IS TABLE OF VARCHAR2(80) INDEX BY BINARY_INTEGER;
710: l_locality tb_locality;

Line 753: ,pay_user_columns puc3

749: and purf1.row_low_range_or_name = purf2.row_low_range_or_name
750: and purf.row_low_range_or_name in
751: (SELECT purf3.row_low_range_or_name
752: FROM pay_user_column_instances_f pucif3
753: ,pay_user_columns puc3
754: ,pay_user_rows_f purf3
755: WHERE purf3.user_table_id = p_user_table_id
756: AND puc3.user_column_name = 'LEVEL'
757: and puc3.legislation_code = 'RO'

Line 787: ,pay_user_columns puc

783: into
784: l_user_table_id
785: ,l_user_column_id_loc
786: FROM pay_user_tables put
787: ,pay_user_columns puc
788: WHERE put.user_table_name = 'RO_LOCALITY_DETAILS'
789: AND put.user_table_id = puc.user_table_id
790: AND puc.user_column_name = 'LOCALITY';
791:

Line 795: ,pay_user_columns puc

791:
792: SELECT puc.user_column_id
793: into l_user_column_id_con
794: FROM pay_user_tables put
795: ,pay_user_columns puc
796: WHERE put.user_table_name = 'RO_LOCALITY_DETAILS'
797: AND put.user_table_id = puc.user_table_id
798: AND puc.user_column_name = 'COUNTY CODE';
799:

Line 803: ,pay_user_columns puc

799:
800: SELECT puc.user_column_id
801: into l_user_column_id_pin
802: FROM pay_user_tables put
803: ,pay_user_columns puc
804: WHERE put.user_table_name = 'RO_LOCALITY_DETAILS'
805: AND put.user_table_id = puc.user_table_id
806: AND puc.user_column_name = 'POSTAL CODE';
807: