APPS.PAY_MX_FF_UDFS dependencies on PAY_USER_COLUMN_INSTANCES

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 1609: ln_usr_col_inst_id pay_user_column_instances.user_column_instance_id%TYPE;

1605: ld_eff_start_date DATE;
1606: ld_eff_end_date DATE;
1607:
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;

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: