DBA Data[Home] [Help]

APPS.PQP_GB_CPX_EXTRACT_FUNCTIONS dependencies on PAY_USER_ROWS_F

Line 390: FROM pay_user_rows_f

386: c_effective_date DATE
387: )
388: IS
389: SELECT user_row_id
390: FROM pay_user_rows_f
391: WHERE user_table_id = c_user_table_id
392: AND row_low_range_or_name = c_user_row_name
393: AND c_effective_date BETWEEN effective_start_date
394: AND effective_end_date

Line 410: -- FROM pay_user_rows_f pur

406: -- (c_user_table_id NUMBER)
407: -- IS
408: -- SELECT pet.element_type_id
409: -- ,pet.element_name
410: -- FROM pay_user_rows_f pur
411: -- ,pay_element_types_f pet
412: -- WHERE pet.element_name = pur.row_low_range_or_name
413: -- AND NVL(pet.business_group_id, g_business_group_id)
414: -- = g_business_group_id

Line 431: pay_user_rows_f pur

427: IS
428: SELECT pur.user_row_id
429: ,SUBSTR(pur.row_low_range_or_name, 4, 1) category
430: FROM pay_user_column_instances_f puci,
431: pay_user_rows_f pur
432: WHERE pur.user_table_id = c_user_table_id
433: AND pur.user_row_id = puci.user_row_id
434: AND puci.user_column_id = c_user_column_id
435: AND puci.business_group_id = g_business_group_id

Line 477: FROM pay_user_rows_f pur

473:
474: CURSOR csr_get_ni_ele_name (c_user_table_id NUMBER)
475: IS
476: SELECT pur.user_row_id, pur.row_low_range_or_name
477: FROM pay_user_rows_f pur
478: WHERE pur.user_table_id = c_user_table_id
479: AND ( ( pur.business_group_id IS NULL
480: AND pur.legislation_code IS NULL
481: )

Line 648: FROM pay_user_rows_f urws,

644: c_value VARCHAR2
645: )
646: IS
647: SELECT extv.VALUE ext_value
648: FROM pay_user_rows_f urws,
649: pay_user_column_instances_f asgv,
650: pay_user_column_instances_f extv
651: WHERE urws.user_table_id = c_user_table_id
652: AND c_effective_date BETWEEN urws.effective_start_date