APPS.PAY_MX_FF_UDFS dependencies on PAY_USER_COLUMN_INSTANCES

Line 1418: DELETE pay_user_column_instances_f

1414: LOOP
1415:
1416: IF ( i <> ln_count ) THEN
1417:
1418: DELETE pay_user_column_instances_f
1419: WHERE user_row_id = rw.user_row_id;
1420:
1421: DELETE pay_user_rows_f
1422: WHERE user_row_id = rw.user_row_id;

Line 1442: value pay_user_column_instances_f.value%TYPE);

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

Line 1454: ln_usr_col_inst_id pay_user_column_instances.user_column_instance_id%TYPE;

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;
1458: ln_ovn NUMBER;

Line 1515: DELETE pay_user_column_instances_f

1511: WHERE row_low_range_or_name = p_contract_name
1512: AND user_table_id = ln_user_table_id
1513: AND ROWNUM = 1;
1514:
1515: DELETE pay_user_column_instances_f
1516: WHERE user_row_id = ln_user_row_id;
1517:
1518: --}
1519: END IF;

Line 1556: ln_contract_days pay_user_column_instances_f.value%TYPE;

1552:
1553: ln_days_year NUMBER;
1554: ln_days_month NUMBER;
1555: ln_legal_emp_id hr_all_organization_units.organization_id%TYPE;
1556: ln_contract_days pay_user_column_instances_f.value%TYPE;
1557:
1558: lv_period_type pay_all_payrolls_f.period_type%TYPE;
1559: rv_contract_name VARCHAR2(80);
1560: