APPS.PAY_CORE_UPGRADE_PKG dependencies on PAY_INPUT_VALUES_F

Line 6: g_jur_name pay_input_values_f.name%type;

2: /* $Header: pycougpk.pkb 120.13.12010000.1 2008/07/27 22:23:46 appldev ship $ */
3:
4: -- Cache Used by Sparse Matrix Run Result Value Purge upgrade.
5: g_leg_code_cached boolean := FALSE;
6: g_jur_name pay_input_values_f.name%type;
7:
8:
9: /* Name : upg_single_lat_bal_tab
10: Purpose : This procedure is used to upgrade to a single

Line 1184: from pay_input_values_f iv

1180: from pay_run_results rr
1181: where rr.assignment_action_id = asgt_action_ids(i))
1182: and not exists
1183: (select 1
1184: from pay_input_values_f iv
1185: where iv.input_value_id = rrv.input_value_id
1186: and run_dates(i) between iv.effective_start_date
1187: and iv.effective_end_date
1188: and iv.name = g_jur_name);