APPS.PAY_IP_RUN_BALANCE_UPGRADE dependencies on PAY_ELEMENT_TYPES_F

Line 62: from pay_element_types_f pet,

58:
59:
60: cursor c_primary_balance(cp_element_type_id in number) is
61: select distinct 'Y'
62: from pay_element_types_f pet,
63: pay_balance_types pbt,
64: pay_input_values_f piv
65: where pbt.input_value_id = piv.input_value_id
66: and piv.element_type_id = pet.element_type_id

Line 102: from pay_element_types_f pet,

98: PROCEDURE upgrade_balance(p_object_id in number)
99: IS
100: cursor c_legislation_code(cp_element_type_id in number) is
101: select pbg.legislation_code
102: from pay_element_types_f pet,
103: per_business_groups pbg
104: where pet.element_type_id = cp_element_type_id
105: and pet.business_group_id = pbg.business_group_id
106: and rownum = 1;

Line 113: from pay_element_types_f pet,

109: select distinct pbt.balance_type_id,
110: pec.classification_name,
111: pet.effective_start_date,
112: pbt.business_group_id
113: from pay_element_types_f pet,
114: pay_input_values_f piv,
115: pay_balance_types pbt,
116: pay_element_classifications pec
117: where pet.element_type_id = cp_element_type_id