APPS.PAY_CA_EOY_RL1_ARCHIVE dependencies on PAY_ELEMENT_TYPES_F

Line 3024: pay_element_types_f pet,

3020: from pay_balance_feeds_f pbf,
3021: pay_balance_types pbt,
3022: pay_balance_types pbt1,
3023: pay_input_values_f piv,
3024: pay_element_types_f pet,
3025: fnd_lookup_values flv
3026: where pbt.balance_name = p_balance_name
3027: and pbf.balance_type_id = pbt.balance_type_id
3028: and pbf.input_value_id = piv.input_value_id

Line 3065: select /*+ index (PET PAY_ELEMENT_TYPES_F_PK) */ distinct prrv1.result_value,

3061: action_type 'B' to consider Balance Adjustments */
3062: cursor cur_non_box_mesg( cp_asgactid in number,
3063: cp_eff_date in date,
3064: cp_start_date in date ) is
3065: select /*+ index (PET PAY_ELEMENT_TYPES_F_PK) */ distinct prrv1.result_value,
3066: prrv2.result_value,
3067: hoi.organization_id,
3068: run_ppa.effective_date,
3069: run_paa.assignment_action_id

Line 3073: , pay_element_types_f pet

3069: run_paa.assignment_action_id
3070: from pay_run_result_values prrv1
3071: , pay_run_result_values prrv2
3072: , pay_run_results prr
3073: , pay_element_types_f pet
3074: , pay_input_values_f piv1
3075: , pay_input_values_f piv2
3076: , pay_assignment_actions run_paa
3077: , pay_payroll_actions run_ppa