APPS.PQP_GB_UNPAID_TEMPLATE dependencies on PAY_USER_ROWS_F

Line 48: (row_low_range_or_name pay_user_rows_f.row_low_range_or_name%TYPE

44: TYPE t_udt_cols IS TABLE OF r_udt_cols_type
45: INDEX BY BINARY_INTEGER;
46:
47: TYPE r_udt_rows_type IS RECORD
48: (row_low_range_or_name pay_user_rows_f.row_low_range_or_name%TYPE
49: ,display_sequence pay_user_rows_f.display_sequence%TYPE
50: ,row_high_range pay_user_rows_f.row_high_range%TYPE
51: ,business_group_id pay_user_rows.business_group_id%TYPE
52: ,legislation_code pay_user_rows.legislation_code%TYPE

Line 49: ,display_sequence pay_user_rows_f.display_sequence%TYPE

45: INDEX BY BINARY_INTEGER;
46:
47: TYPE r_udt_rows_type IS RECORD
48: (row_low_range_or_name pay_user_rows_f.row_low_range_or_name%TYPE
49: ,display_sequence pay_user_rows_f.display_sequence%TYPE
50: ,row_high_range pay_user_rows_f.row_high_range%TYPE
51: ,business_group_id pay_user_rows.business_group_id%TYPE
52: ,legislation_code pay_user_rows.legislation_code%TYPE
53: );

Line 50: ,row_high_range pay_user_rows_f.row_high_range%TYPE

46:
47: TYPE r_udt_rows_type IS RECORD
48: (row_low_range_or_name pay_user_rows_f.row_low_range_or_name%TYPE
49: ,display_sequence pay_user_rows_f.display_sequence%TYPE
50: ,row_high_range pay_user_rows_f.row_high_range%TYPE
51: ,business_group_id pay_user_rows.business_group_id%TYPE
52: ,legislation_code pay_user_rows.legislation_code%TYPE
53: );
54:

Line 487: l_user_row_id pay_user_rows_f.user_row_id%TYPE;

483: l_proc_step NUMBER(20,10);
484:
485: l_user_table_id pay_user_tables.user_table_id%TYPE;
486: l_user_column_id pay_user_columns.user_column_id%TYPE;
487: l_user_row_id pay_user_rows_f.user_row_id%TYPE;
488: l_udt_rowid rowid ;
489: l_udt_cols_rowid rowid;
490: l_udt_rows_rowid rowid;
491: i number;

Line 576: INSERT INTO pay_user_rows_f

572: ,p_user_row_id => l_user_row_id
573: ,p_business_group_id => p_business_group_id
574: );
575:
576: INSERT INTO pay_user_rows_f
577: (user_row_id
578: ,effective_start_date
579: ,effective_end_date
580: ,business_group_id

Line 1830: FROM pay_user_rows_f

1826:
1827: CURSOR csr_get_usr_row_id
1828: IS
1829: SELECT user_row_id
1830: FROM pay_user_rows_f
1831: WHERE user_table_id = p_udt_id;
1832:
1833: --
1834: l_proc_step NUMBER(20,10);

Line 1893: -- Delete pay_user_rows_f for this table id

1889: LOOP
1890: FETCH csr_get_usr_row_id INTO l_usr_row_id;
1891: EXIT WHEN csr_get_usr_row_id%NOTFOUND;
1892:
1893: -- Delete pay_user_rows_f for this table id
1894: l_proc_step := 50;
1895: IF g_debug THEN
1896: debug(l_proc_name, l_proc_step);
1897: END IF;

Line 1906: DELETE pay_user_rows_f

1902: ,p_validation_start_date => NULL
1903: ,p_dt_delete_mode => 'ZAP'
1904: );
1905:
1906: DELETE pay_user_rows_f
1907: WHERE user_row_id = l_usr_row_id;
1908:
1909: END LOOP;
1910: CLOSE csr_get_usr_row_id;