APPS.PAY_NL_GENERAL dependencies on PAY_INPUT_VALUES_F

Line 453: from pay_input_values_f iv

449: ,p_element_type_id IN NUMBER
450: ,p_input_value_name IN VARCHAR2) RETURN VARCHAR2 IS
451: CURSOR cur_iv_id(lp_element_type_id number,lp_input_value_name varchar2) IS
452: SELECT iv.input_value_id
453: from pay_input_values_f iv
454: where iv.name=lp_input_value_name
455: and iv.element_type_id=lp_element_type_id;
456: v_cur_iv_id cur_iv_id%ROWTYPE;
457:

Line 497: ,pay_input_values_f piv

493: ,lp_si_type VARCHAR2) IS
494: SELECT prrv1.result_value si_type_name
495: FROM pay_balance_feeds_f pbf
496: ,pay_balance_types pbt
497: ,pay_input_values_f piv
498: ,pay_input_values_f piv1
499: ,pay_input_values_f piv2
500: ,pay_element_types_f pet
501: ,pay_run_results prr

Line 498: ,pay_input_values_f piv1

494: SELECT prrv1.result_value si_type_name
495: FROM pay_balance_feeds_f pbf
496: ,pay_balance_types pbt
497: ,pay_input_values_f piv
498: ,pay_input_values_f piv1
499: ,pay_input_values_f piv2
500: ,pay_element_types_f pet
501: ,pay_run_results prr
502: ,pay_run_result_values prrv

Line 499: ,pay_input_values_f piv2

495: FROM pay_balance_feeds_f pbf
496: ,pay_balance_types pbt
497: ,pay_input_values_f piv
498: ,pay_input_values_f piv1
499: ,pay_input_values_f piv2
500: ,pay_element_types_f pet
501: ,pay_run_results prr
502: ,pay_run_result_values prrv
503: ,pay_run_result_values prrv1

Line 1123: from pay_input_values_f

1119: IS
1120: l_input_value_id number;
1121: BEGIN
1122: select input_value_id into l_input_value_id
1123: from pay_input_values_f
1124: where element_type_id = p_element_type_id
1125: and name = p_input_value_name
1126: and p_effective_date between effective_start_date and effective_end_date
1127: and legislation_code='NL';

Line 1371: pay_input_values_f piv

1367: pay_run_results prr,
1368: pay_run_result_values prv,
1369: pay_element_types_f pet,
1370: pay_element_classifications pec,
1371: pay_input_values_f piv
1372: where
1373: paa.payroll_action_id=ppa.payroll_action_id
1374: and paa.SOURCE_ACTION_ID is not null
1375: -- and ppa.payroll_action_id = paa.payroll_action_id

Line 1417: pay_input_values_f piv

1413: pay_run_result_values prv,
1414: pay_element_types_f pet,
1415: pay_element_classifications pec,
1416: pay_sub_classification_rules_f pecs,
1417: pay_input_values_f piv
1418: where
1419: paa.payroll_action_id=ppa.payroll_action_id
1420: and paa.SOURCE_ACTION_ID is not null
1421: and ppa.payroll_action_id = paa.payroll_action_id

Line 1472: pay_input_values_f piv

1468: pay_run_results prr,
1469: pay_run_result_values prv,
1470: pay_run_result_values prv1,
1471: pay_action_contexts pac,
1472: pay_input_values_f piv
1473: where
1474: paa.payroll_action_id=ppa.payroll_action_id
1475: and paa.SOURCE_ACTION_ID is not null
1476: and ppa.payroll_action_id = paa.payroll_action_id

Line 1502: pay_input_values_f piv

1498: pay_payroll_actions ppa,
1499: pay_assignment_actions paa,
1500: pay_run_results prr,
1501: pay_run_result_values prv,
1502: pay_input_values_f piv
1503: Where
1504: paa.payroll_action_id=ppa.payroll_action_id
1505: and paa.SOURCE_ACTION_ID is not null
1506: and ppa.payroll_action_id = paa.payroll_action_id

Line 1553: pay_input_values_f piv

1549: pay_run_results prr,
1550: pay_run_result_values prv,
1551: pay_element_types_f pet,
1552: pay_element_classifications pec,
1553: pay_input_values_f piv
1554: where
1555: paa.payroll_action_id=ppa.payroll_action_id
1556: and paa.SOURCE_ACTION_ID is not null
1557: -- and ppa.payroll_action_id = paa.payroll_action_id

Line 1709: pay_input_values_f piv

1705: pay_run_result_values prv,
1706: pay_element_types_f pet,
1707: pay_element_classifications pec,
1708: pay_sub_classification_rules_f pecs,
1709: pay_input_values_f piv
1710: where
1711: paa.payroll_action_id=ppa.payroll_action_id
1712: and paa.SOURCE_ACTION_ID is not null
1713: and paa.action_status='C'