APPS.PAY_CA_EMP_TAX_INF dependencies on PAY_ELEMENT_ENTRIES_F

Line 982: from pay_element_entries_f pee,

978: 0,
979: peev.screen_entry_value|| '.00',
980: peev.screen_entry_value
981: )
982: from pay_element_entries_f pee,
983: pay_element_entry_values_f peev,
984: pay_input_values_f piv
985: WHERE l_effective_date
986: between pee.effective_start_date AND pee.effective_end_date

Line 1172: pay_element_entries_f pee,

1168: l_exemption in VARCHAR2) IS
1169: select nvl(sum(pev.screen_entry_value),0)
1170: from pay_element_types_f pet,
1171: pay_input_values_f piv,
1172: pay_element_entries_f pee,
1173: pay_element_entry_Values_f pev,
1174: pay_payroll_actions ppa,
1175: pay_assignment_actions paa,
1176: pay_payroll_actions ppa2

Line 1271: from pay_element_entries_f

1267: where payroll_action_id = p_payroll_action_id;
1268:
1269: cursor csr_get_ele_entry_info is
1270: select creator_type, source_id, source_asg_action_id,assignment_id
1271: from pay_element_entries_f
1272: where element_entry_id = p_element_entry_id;
1273:
1274: cursor csr_get_current_location(l_asst_id in number,l_cur_date in date) is
1275: select hla.region_1