APPS.PAY_PURGE_PKG dependencies on PAY_INPUT_VALUES_F

Line 404: ,pay_input_values_f piv

400: use_nl (piv prrv) */
401: count(1)
402: from
403: pay_balance_feeds_f pbf
404: ,pay_input_values_f piv
405: ,pay_run_result_values prrv
406: where
407: pbf.balance_type_id = p_baltypid
408: and pbf.effective_start_date <= p_purge_date

Line 439: ,pay_input_values_f piv

435: use_nl (piv prr paa ppa purge_paa prrv) */
436: 1
437: from
438: pay_balance_feeds_f pbf
439: ,pay_input_values_f piv
440: ,pay_run_results prr
441: ,pay_assignment_actions paa
442: ,pay_payroll_actions ppa
443: ,pay_assignment_actions purge_paa

Line 1156: l_iv_id pay_input_values_f.input_value_id%type;

1152: c_iv_limit constant number := 15; -- which includes Jurdisdiction.
1153:
1154: l_iv_count number;
1155: l_et_id pay_element_types_f.element_type_id%type;
1156: l_iv_id pay_input_values_f.input_value_id%type;
1157: l_el_id pay_element_links_f.element_link_id%type;
1158: l_et_name pay_element_types_f.element_name%type;
1159: l_iv_name pay_input_values_f.name%type;
1160: l_bg_name per_business_groups.name%type;

Line 1159: l_iv_name pay_input_values_f.name%type;

1155: l_et_id pay_element_types_f.element_type_id%type;
1156: l_iv_id pay_input_values_f.input_value_id%type;
1157: l_el_id pay_element_links_f.element_link_id%type;
1158: l_et_name pay_element_types_f.element_name%type;
1159: l_iv_name pay_input_values_f.name%type;
1160: l_bg_name per_business_groups.name%type;
1161: l_et_count number := 0;
1162:
1163: type et_r is record

Line 1420: pay_input_values_f piv,

1416: -- across the whole of time.
1417: select 1
1418: into l_dummy
1419: from pay_balance_feeds_f pbf,
1420: pay_input_values_f piv,
1421: pay_element_types_f pet,
1422: pay_element_classifications pec
1423: where pbf.balance_type_id = c1rec.balance_type_id
1424: and piv.input_value_id = pbf.input_value_id