APPS.PAY_MX_FF_UDFS dependencies on PAY_USER_COLUMNS

Line 346: FROM pay_user_columns

342:
343:
344: SELECT user_column_name
345: INTO v_work_sched_name
346: FROM pay_user_columns
347: WHERE user_column_id = v_ws_id
348: AND NVL(business_group_id, p_bg) = p_bg
349: AND NVL(legislation_code,'MX') = 'MX';
350:

Line 504: FROM pay_user_columns

500: v_ws_id := fnd_number.canonical_to_number(p_asg_work_sched);
501:
502: SELECT user_column_name
503: INTO v_work_sched_name
504: FROM pay_user_columns
505: WHERE user_column_id = v_ws_id
506: AND NVL(business_group_id, p_bg) = p_bg
507: AND NVL(legislation_code,'MX') = 'MX';
508:

Line 819: pay_user_columns puc

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'
823: AND puc.user_table_id = put.user_table_id

Line 840: pay_user_columns puc

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'
844: AND puc.user_table_id = PUT.user_table_id

Line 1441: col_name pay_user_columns.user_column_name%TYPE,

1437: p_exists IN BOOLEAN)
1438: IS
1439:
1440: TYPE user_col_rec is RECORD (
1441: col_name pay_user_columns.user_column_name%TYPE,
1442: value pay_user_column_instances_f.value%TYPE);
1443:
1444: TYPE col_tab IS TABLE OF user_col_rec
1445: INDEX BY BINARY_INTEGER;

Line 1457: ln_user_column_id pay_user_columns.user_column_id%TYPE;

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;
1458: ln_ovn NUMBER;
1459:
1460: BEGIN
1461: --{

Line 1527: FROM pay_user_columns

1523: LOOP
1524: --{
1525: SELECT user_column_id
1526: INTO ln_user_column_id
1527: FROM pay_user_columns
1528: WHERE user_table_id = ln_user_table_id
1529: AND user_column_name = lt_col_det_tab(i).col_name;
1530:
1531: pay_user_column_instance_api.create_user_column_instance(