APPS.HR_LEGISLATION dependencies on PAY_INPUT_VALUES_F

Line 579: elsif l_table_name = 'PAY_INPUT_VALUES_F' then

575: and bt.created_by > 2
576: and bt.last_updated_by > 2
577: and replace(ltrim(rtrim(upper(bt.BALANCE_NAME))), ' ', '_') = replace(ltrim(rtrim(upper(P_SURROGATE_KEY_NAME))), ' ', '_'));
578:
579: elsif l_table_name = 'PAY_INPUT_VALUES_F' then
580:
581: Select 'Y' into v_exists from dual where exists(
582: select null
583: from pay_input_values_f iv,

Line 583: from pay_input_values_f iv,

579: elsif l_table_name = 'PAY_INPUT_VALUES_F' then
580:
581: Select 'Y' into v_exists from dual where exists(
582: select null
583: from pay_input_values_f iv,
584: pay_element_types_f et
585: where et.element_type_id = iv.element_type_id
586: and iv.business_group_id is null
587: and iv.legislation_code = p_legislation_code

Line 614: pay_input_values_f piv,

610:
611: Select 'Y' into v_exists from dual where exists(
612: select null
613: from pay_balance_feeds_f bf,
614: pay_input_values_f piv,
615: pay_balance_types bt
616: where piv.input_value_id = bf.INPUT_VALUE_ID
617: and bt.balance_type_id = bf.balance_type_id
618: and bf.business_group_id is null

Line 2687: from pay_input_values_f

2683:
2684: BEGIN
2685: select distinct null
2686: into l_null_return
2687: from pay_input_values_f
2688: where input_value_id = bal_feeds.input_value_id;
2689:
2690: EXCEPTION WHEN NO_DATA_FOUND THEN
2691: crt_exc('Parent input value does not exist');

Line 6872: -- PAY_INPUT_VALUES_F_TL

6868: -- They are:
6869: -- PAY_BALANCE_TYPES_TL
6870: -- PAY_ELEMENT_CLASSIFICATIONS_TL
6871: -- PAY_ELEMENT_TYPES_F_TL
6872: -- PAY_INPUT_VALUES_F_TL
6873: -- PAY_PAYMENT_TYPES_TL
6874: -- PER_ASSIGNMENT_STATUS_TYPES_TL
6875: -- PER_ASSIGNMENT_INFO_TYPES_TL
6876: -- PAY_MONETARY_UNITS_TL

Line 7235: -- Seeds the PAY_INPUT_VALUES_F_TL table.

7231:
7232: PROCEDURE install_pivft
7233: -----------------------
7234: IS
7235: -- Seeds the PAY_INPUT_VALUES_F_TL table.
7236:
7237: CURSOR c_input_values IS
7238: select
7239: IV.INPUT_VALUE_ID,

Line 7248: from PAY_INPUT_VALUES_F IV,

7244: IV.LAST_UPDATED_BY,
7245: IV.LAST_UPDATE_LOGIN,
7246: IV.CREATED_BY,
7247: IV.CREATION_DATE
7248: from PAY_INPUT_VALUES_F IV,
7249: FND_LANGUAGES L,
7250: FND_LANGUAGES B
7251: where L.INSTALLED_FLAG in ('I', 'B')
7252: and B.INSTALLED_FLAG = 'B'

Line 7256: from PAY_INPUT_VALUES_F_TL IVT

7252: and B.INSTALLED_FLAG = 'B'
7253: and NVL(TO_CHAR(IV.BUSINESS_GROUP_ID),'Null Value')='Null Value'
7254: and not exists (
7255: select '1'
7256: from PAY_INPUT_VALUES_F_TL IVT
7257: where IVT.INPUT_VALUE_ID = IV.INPUT_VALUE_ID
7258: and IVT.language = l.language_code);
7259:
7260: l_counter NUMBER(3) := 0;

Line 7285: insert into PAY_INPUT_VALUES_F_TL

7281: l_translated_value:=l_rec.NAME;
7282: end if;
7283: -- Insert all selected rows into the TL table.
7284: -- If the row exist in the TL table then it will be ignored.
7285: insert into PAY_INPUT_VALUES_F_TL
7286: (
7287: INPUT_VALUE_ID,
7288: NAME,
7289: LANGUAGE,

Line 7310: from PAY_INPUT_VALUES_F_TL IVT

7306: l_rec.CREATION_DATE
7307: from dual
7308: where not exists (
7309: select '1'
7310: from PAY_INPUT_VALUES_F_TL IVT
7311: where IVT.INPUT_VALUE_ID = l_rec.INPUT_VALUE_ID
7312: and IVT.language = l_rec.trans_lang);
7313:
7314: l_counter := l_counter + 1;