APPS.PAY_BALANCE_UPLOAD dependencies on PAY_ELEMENT_ENTRY_VALUES_F

Line 2079: l_wcb_acc_number pay_element_entry_values_f.screen_entry_value%type := null;

2075: l_reporting_unit_id number := 0;
2076: l_assignment_job_name per_jobs.name%type;
2077: l_jur_code fnd_lookup_values.lookup_code%type;
2078: l_formula_id ff_formulas_f.formula_id%type;
2079: l_wcb_acc_number pay_element_entry_values_f.screen_entry_value%type := null;
2080: l_wcb_rate_code pay_element_entry_values_f.screen_entry_value%type := null;
2081: l_assignment_action_id pay_assignment_actions.assignment_action_id%type;
2082:
2083: CURSOR c_assignment_jur

Line 2080: l_wcb_rate_code pay_element_entry_values_f.screen_entry_value%type := null;

2076: l_assignment_job_name per_jobs.name%type;
2077: l_jur_code fnd_lookup_values.lookup_code%type;
2078: l_formula_id ff_formulas_f.formula_id%type;
2079: l_wcb_acc_number pay_element_entry_values_f.screen_entry_value%type := null;
2080: l_wcb_rate_code pay_element_entry_values_f.screen_entry_value%type := null;
2081: l_assignment_action_id pay_assignment_actions.assignment_action_id%type;
2082:
2083: CURSOR c_assignment_jur
2084: IS

Line 2099: pay_element_entry_values_f peev,

2095: IS
2096: select peev.screen_entry_value
2097: from pay_element_entries_f pee,
2098: pay_element_types_f pet,
2099: pay_element_entry_values_f peev,
2100: pay_input_values_f piv
2101: where pee.assignment_id = p_asg_id
2102: and pet.element_name = 'WCB'
2103: and pet.element_type_id = pee.element_type_id