APPS.PAY_MX_FF_UDFS dependencies on PAY_USER_COLUMNS

Line 359: FROM pay_user_columns

355:
356:
357: SELECT user_column_name
358: INTO v_work_sched_name
359: FROM pay_user_columns
360: WHERE user_column_id = v_ws_id
361: AND NVL(business_group_id, p_bg) = p_bg
362: AND NVL(legislation_code,'MX') = 'MX';
363:

Line 517: FROM pay_user_columns

513: v_ws_id := fnd_number.canonical_to_number(p_asg_work_sched);
514:
515: SELECT user_column_name
516: INTO v_work_sched_name
517: FROM pay_user_columns
518: WHERE user_column_id = v_ws_id
519: AND NVL(business_group_id, p_bg) = p_bg
520: AND NVL(legislation_code,'MX') = 'MX';
521:

Line 832: pay_user_columns puc

828:
829: SELECT 'Y'
830: INTO l_exists
831: FROM pay_user_tables put,
832: pay_user_columns puc
833: WHERE puc.user_column_name = p_ws_name
834: AND nvl(puc.business_group_id, p_bg_id) = p_bg_id
835: AND nvl(puc.legislation_code,'MX') = 'MX'
836: AND puc.user_table_id = put.user_table_id

Line 853: pay_user_columns puc

849: BEGIN
850: SELECT puc.user_column_name
851: INTO v_ws_name
852: FROM pay_user_tables put,
853: pay_user_columns puc
854: WHERE puc.user_column_id = p_ws_name
855: AND nvl(puc.business_group_id, p_bg_id) = p_bg_id
856: AND nvl(puc.legislation_code,'MX') = 'MX'
857: AND puc.user_table_id = PUT.user_table_id

Line 1596: col_name pay_user_columns.user_column_name%TYPE,

1592: p_exists IN BOOLEAN)
1593: IS
1594:
1595: TYPE user_col_rec is RECORD (
1596: col_name pay_user_columns.user_column_name%TYPE,
1597: value pay_user_column_instances_f.value%TYPE);
1598:
1599: TYPE col_tab IS TABLE OF user_col_rec
1600: INDEX BY BINARY_INTEGER;

Line 1612: ln_user_column_id pay_user_columns.user_column_id%TYPE;

1608: ln_user_table_id pay_user_tables.user_table_id%TYPE;
1609: ln_usr_col_inst_id pay_user_column_instances.user_column_instance_id%TYPE;
1610: ln_user_row_id pay_user_rows_f.user_row_id%TYPE;
1611: ln_dsp_seq pay_user_rows_f.display_sequence%TYPE;
1612: ln_user_column_id pay_user_columns.user_column_id%TYPE;
1613: ln_ovn NUMBER;
1614:
1615: BEGIN
1616: --{

Line 1682: FROM pay_user_columns

1678: LOOP
1679: --{
1680: SELECT user_column_id
1681: INTO ln_user_column_id
1682: FROM pay_user_columns
1683: WHERE user_table_id = ln_user_table_id
1684: AND user_column_name = lt_col_det_tab(i).col_name;
1685:
1686: pay_user_column_instance_api.create_user_column_instance(