APPS.PAY_SE_POPULATE_COUNTRIES dependencies on PAY_USER_ROWS_F

Line 18: FROM pay_user_rows_f

14: SELECT TERRITORY_CODE||' - '||territory_short_name territory_short_name
15: FROM fnd_territories_vl
16: WHERE UPPER(TERRITORY_CODE||' - '||territory_short_name) NOT IN
17: ( SELECT UPPER(row_low_range_or_name)
18: FROM pay_user_rows_f
19: WHERE user_table_id=p_table_id
20: AND business_group_id = p_bg )
21: ORDER BY TERRITORY_CODE;
22:

Line 29: FROM pay_user_rows_f

25: ,display_sequence
26: ,object_version_number
27: ,UPPER(row_low_range_or_name) row_low_range_or_name
28: ,row_high_range
29: FROM pay_user_rows_f
30: WHERE user_table_id=p_table_id
31: AND business_group_id = p_bg
32: AND UPPER(row_low_range_or_name) IN
33: (SELECT UPPER(territory_short_name)

Line 58: l_row_low_range_or_name pay_user_rows_f.ROW_LOW_RANGE_OR_NAME%TYPE;

54: l_effective_end_date DATE;
55: l_effective_date DATE;
56: l_object_version_number NUMBER;
57: l_display_sequence NUMBER;
58: l_row_low_range_or_name pay_user_rows_f.ROW_LOW_RANGE_OR_NAME%TYPE;
59:
60: BEGIN
61:
62: -- Get the Table ID for the Table PER DIEM OVERSEAS NORMAL AMOUNT

Line 127: FROM pay_user_rows_f

123:
124:
125: SELECT max(DISPLAY_SEQUENCE)
126: INTO l_display_sequence
127: FROM pay_user_rows_f
128: WHERE user_table_id=l_user_table_id
129: AND business_group_id = p_business_group_id;
130:
131: IF l_display_sequence IS NULL THEN