DBA Data[Home] [Help]

APPS.PQP_GB_SWF_ARCHIVE dependencies on PAY_USER_COLUMNS

Line 2075: pay_user_columns col,

2071:
2072: cursor get_work_pattern(p_work_pattern in varchar2) is
2073: select val.value
2074: from pay_user_tables tab,
2075: pay_user_columns col,
2076: pay_user_rows_f r,
2077: pay_user_column_instances_f val
2078: where tab.user_table_name = 'PQP_COMPANY_WORK_PATTERNS'
2079: and tab.user_table_id=col.user_table_id

Line 2092: pay_user_columns col,

2088:
2089: cursor get_wk_per_yr(p_column_no in number,p_contract_type in varchar2) is
2090: select val.value
2091: from pay_user_tables tab,
2092: pay_user_columns col,
2093: pay_user_rows_f r,
2094: pay_user_column_instances_f val
2095: where tab.user_table_name = 'PQP_CONTRACT_TYPES'
2096: and tab.business_group_id = g_business_group_id