APPS.PAY_MX_FF_UDFS dependencies on PAY_USER_TABLES

Line 771: ,pay_user_tables put

767: BEGIN
768: SELECT put.user_table_name
769: INTO c_ws_tab_name
770: FROM hr_organization_information hoi
771: ,pay_user_tables put
772: WHERE hoi.organization_id = p_bg_id
773: AND hoi.org_information_context = 'Work Schedule'
774: AND hoi.org_information1 = put.user_table_id ;
775:

Line 818: FROM pay_user_tables put,

814: BEGIN
815:
816: SELECT 'Y'
817: INTO l_exists
818: FROM pay_user_tables put,
819: pay_user_columns puc
820: WHERE puc.user_column_name = p_ws_name
821: AND nvl(puc.business_group_id, p_bg_id) = p_bg_id
822: AND nvl(puc.legislation_code,'MX') = 'MX'

Line 839: FROM pay_user_tables put,

835:
836: BEGIN
837: SELECT puc.user_column_name
838: INTO v_ws_name
839: FROM pay_user_tables put,
840: pay_user_columns puc
841: WHERE puc.user_column_id = p_ws_name
842: AND nvl(puc.business_group_id, p_bg_id) = p_bg_id
843: AND nvl(puc.legislation_code,'MX') = 'MX'

Line 1018: FROM pay_user_tables

1014: and cp_eff_date between pev.effective_start_date and pev.effective_end_date ;
1015:
1016: CURSOR c_idw_user_table_check( cp_idw_user_table_name IN VARCHAR2 ) IS
1017: SELECT 'Y'
1018: FROM pay_user_tables
1019: WHERE user_table_name = cp_idw_user_table_name;
1020:
1021: CURSOR c_idw_factor_table_US ( cp_idw_lookup_code IN VARCHAR2 ) IS
1022: SELECT meaning

Line 1397: FROM pay_user_tables

1393: BEGIN
1394:
1395: SELECT user_table_id
1396: INTO ln_user_table_id
1397: FROM pay_user_tables
1398: WHERE user_table_name = p_user_table_name
1399: AND ( legislation_code is NULL OR
1400: legislation_code = 'MX');
1401:

Line 1453: ln_user_table_id pay_user_tables.user_table_id%TYPE;

1449: ld_eff_date DATE;
1450: ld_eff_start_date DATE;
1451: ld_eff_end_date DATE;
1452:
1453: ln_user_table_id pay_user_tables.user_table_id%TYPE;
1454: ln_usr_col_inst_id pay_user_column_instances.user_column_instance_id%TYPE;
1455: ln_user_row_id pay_user_rows_f.user_row_id%TYPE;
1456: ln_dsp_seq pay_user_rows_f.display_sequence%TYPE;
1457: ln_user_column_id pay_user_columns.user_column_id%TYPE;

Line 1476: FROM pay_user_tables

1472: lt_col_det_tab(4).value := p_days_in_year * 8;
1473:
1474: SELECT user_table_id
1475: INTO ln_user_table_id
1476: FROM pay_user_tables
1477: WHERE user_table_name = 'PQP_CONTRACT_TYPES'
1478: AND (legislation_code is NULL
1479: OR legislation_code = 'MX');
1480: