DBA Data[Home] [Help]

APPS.PAY_PEU_BUS dependencies on PAY_EVENT_UPDATES

Line 29: , pay_event_updates peu

25: --
26: cursor csr_sec_grp is
27: select pbg.security_group_id
28: from per_business_groups pbg
29: , pay_event_updates peu
30: where peu.event_update_id = p_event_update_id
31: and pbg.business_group_id = peu.business_group_id;
32: --
33: -- Declare local variables

Line 89: , pay_event_updates peu

85: --
86: cursor csr_leg_code is
87: select pbg.legislation_code
88: from per_business_groups pbg
89: , pay_event_updates peu
90: where peu.event_update_id = p_event_update_id
91: and pbg.business_group_id (+) = peu.business_group_id;
92: --
93: -- Declare local variables

Line 415: from pay_event_updates

411: --
412: cursor c_duplicate_row
413: is
414: select '1'
415: from pay_event_updates
416: where nvl(table_name,'~') = nvl(p_rec.table_name,'~')
417: and nvl(event_type,'~') = nvl(p_rec.event_type,-1)
418: and nvl(column_name,'~') = nvl(p_rec.column_name,'~')
419: and change_type = p_rec.change_type