APPS.PAY_MX_FF_UDFS dependencies on PAY_USER_COLUMN_INSTANCES_F

Line 1573: DELETE pay_user_column_instances_f

1569: LOOP
1570:
1571: IF ( i <> ln_count ) THEN
1572:
1573: DELETE pay_user_column_instances_f
1574: WHERE user_row_id = rw.user_row_id;
1575:
1576: DELETE pay_user_rows_f
1577: WHERE user_row_id = rw.user_row_id;

Line 1597: value pay_user_column_instances_f.value%TYPE);

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;
1601:

Line 1670: DELETE pay_user_column_instances_f

1666: WHERE row_low_range_or_name = p_contract_name
1667: AND user_table_id = ln_user_table_id
1668: AND ROWNUM = 1;
1669:
1670: DELETE pay_user_column_instances_f
1671: WHERE user_row_id = ln_user_row_id;
1672:
1673: --}
1674: END IF;

Line 1711: ln_contract_days pay_user_column_instances_f.value%TYPE;

1707:
1708: ln_days_year NUMBER;
1709: ln_days_month NUMBER;
1710: ln_legal_emp_id hr_all_organization_units.organization_id%TYPE;
1711: ln_contract_days pay_user_column_instances_f.value%TYPE;
1712:
1713: lv_period_type pay_all_payrolls_f.period_type%TYPE;
1714: rv_contract_name VARCHAR2(80);
1715: