APPS.HR_LEGISLATION dependencies on PAY_INPUT_VALUES_F

Line 2441: from pay_input_values_f

2437:
2438: BEGIN
2439: select distinct null
2440: into l_null_return
2441: from pay_input_values_f
2442: where input_value_id = bal_feeds.input_value_id;
2443:
2444: EXCEPTION WHEN NO_DATA_FOUND THEN
2445: crt_exc('Parent input value does not exist');

Line 6622: -- PAY_INPUT_VALUES_F_TL

6618: -- They are:
6619: -- PAY_BALANCE_TYPES_TL
6620: -- PAY_ELEMENT_CLASSIFICATIONS_TL
6621: -- PAY_ELEMENT_TYPES_F_TL
6622: -- PAY_INPUT_VALUES_F_TL
6623: -- PAY_PAYMENT_TYPES_TL
6624: -- PER_ASSIGNMENT_STATUS_TYPES_TL
6625: -- PER_ASSIGNMENT_INFO_TYPES_TL
6626: -- PAY_MONETARY_UNITS_TL

Line 6985: -- Seeds the PAY_INPUT_VALUES_F_TL table.

6981:
6982: PROCEDURE install_pivft
6983: -----------------------
6984: IS
6985: -- Seeds the PAY_INPUT_VALUES_F_TL table.
6986:
6987: CURSOR c_input_values IS
6988: select
6989: IV.INPUT_VALUE_ID,

Line 6998: from PAY_INPUT_VALUES_F IV,

6994: IV.LAST_UPDATED_BY,
6995: IV.LAST_UPDATE_LOGIN,
6996: IV.CREATED_BY,
6997: IV.CREATION_DATE
6998: from PAY_INPUT_VALUES_F IV,
6999: FND_LANGUAGES L,
7000: FND_LANGUAGES B
7001: where L.INSTALLED_FLAG in ('I', 'B')
7002: and B.INSTALLED_FLAG = 'B'

Line 7006: from PAY_INPUT_VALUES_F_TL IVT

7002: and B.INSTALLED_FLAG = 'B'
7003: and NVL(TO_CHAR(IV.BUSINESS_GROUP_ID),'Null Value')='Null Value'
7004: and not exists (
7005: select '1'
7006: from PAY_INPUT_VALUES_F_TL IVT
7007: where IVT.INPUT_VALUE_ID = IV.INPUT_VALUE_ID
7008: and IVT.language = l.language_code);
7009:
7010: l_counter NUMBER(3) := 0;

Line 7035: insert into PAY_INPUT_VALUES_F_TL

7031: l_translated_value:=l_rec.NAME;
7032: end if;
7033: -- Insert all selected rows into the TL table.
7034: -- If the row exist in the TL table then it will be ignored.
7035: insert into PAY_INPUT_VALUES_F_TL
7036: (
7037: INPUT_VALUE_ID,
7038: NAME,
7039: LANGUAGE,

Line 7060: from PAY_INPUT_VALUES_F_TL IVT

7056: l_rec.CREATION_DATE
7057: from dual
7058: where not exists (
7059: select '1'
7060: from PAY_INPUT_VALUES_F_TL IVT
7061: where IVT.INPUT_VALUE_ID = l_rec.INPUT_VALUE_ID
7062: and IVT.language = l_rec.trans_lang);
7063:
7064: l_counter := l_counter + 1;