DBA Data[Home] [Help]

APPS.PAY_GB_PAYROLL_ACTIONS_PKG dependencies on PAY_ELEMENT_ENTRIES_F

Line 364: pay_element_entries_f pee,

360: --
361: cursor element_type_value(p_assig_act_id NUMBER) is
362: SELECT peev.screen_entry_value
363: FROM pay_element_entry_values_f peev,
364: pay_element_entries_f pee,
365: pay_assignment_actions paa
366: WHERE pee.element_entry_id = peev.element_entry_id
367: AND pee.assignment_id = paa.assignment_id
368: AND paa.assignment_action_id = p_assig_act_id

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

2792: -- This cursor gets the screen_entry_value from pay_element_entry_values_f.
2793: -- This is the salary amount
2794: -- obtained when the pay basis isn't null. The pay basis and assignment_id
2795: -- are passed in by the view. A check is made on the effective date of
2796: -- pay_element_entry_values_f and pay_element_entries_f as they're datetracked.
2797: --
2798: cursor csr_lookup is
2799: select sum(eev.screen_entry_value)
2800: from pay_element_entry_values_f eev,

Line 2802: pay_element_entries_f pe

2798: cursor csr_lookup is
2799: select sum(eev.screen_entry_value)
2800: from pay_element_entry_values_f eev,
2801: per_pay_bases ppb,
2802: pay_element_entries_f pe
2803: where ppb.pay_basis_id +0 = p_pay_basis_id
2804: and pe.assignment_id = p_assignment_id
2805: and eev.input_value_id = ppb.input_value_id
2806: and eev.element_entry_id = pe.element_entry_id