APPS.PAY_GB_PAYROLL_ACTIONS_PKG dependencies on PAY_ELEMENT_ENTRIES_F

Line 372: pay_element_entries_f pee,

368: --
369: cursor element_type_value(p_assig_act_id NUMBER) is
370: SELECT peev.screen_entry_value
371: FROM pay_element_entry_values_f peev,
372: pay_element_entries_f pee,
373: pay_assignment_actions paa
374: WHERE pee.element_entry_id = peev.element_entry_id
375: AND pee.assignment_id = paa.assignment_id
376: AND paa.assignment_action_id = p_assig_act_id

Line 3197: -- pay_element_entry_values_f and pay_element_entries_f as they're datetracked.

3193: -- This cursor gets the screen_entry_value from pay_element_entry_values_f.
3194: -- This is the salary amount
3195: -- obtained when the pay basis isn't null. The pay basis and assignment_id
3196: -- are passed in by the view. A check is made on the effective date of
3197: -- pay_element_entry_values_f and pay_element_entries_f as they're datetracked.
3198: --
3199: cursor csr_lookup is
3200: select sum(eev.screen_entry_value)
3201: from pay_element_entry_values_f eev,

Line 3203: pay_element_entries_f pe

3199: cursor csr_lookup is
3200: select sum(eev.screen_entry_value)
3201: from pay_element_entry_values_f eev,
3202: per_pay_bases ppb,
3203: pay_element_entries_f pe
3204: where ppb.pay_basis_id +0 = p_pay_basis_id
3205: and pe.assignment_id = p_assignment_id
3206: and eev.input_value_id = ppb.input_value_id
3207: and eev.element_entry_id = pe.element_entry_id