DBA Data[Home] [Help]

APPS.PAY_HK_IR56_REPORT dependencies on PER_ASSIGNMENTS_F

Line 28: -- by secured views per_assignments_f and per_people_f resp from queries.

24: -- Included checkfile command too.
25: -- 19 Feb 03 apunekar 115.4 Bug#2810178 Removed no. of copies passed to fnd_request.set_print_options
26: -- 25 Feb 03 apunekar 115.6 Bug#2810178 Reverted fix
27: -- 29 May 03 kaverma 115.7 Bug#2920731 Replaced per_all_assignments_f and per_all_people_f
28: -- by secured views per_assignments_f and per_people_f resp from queries.
29: -----------------------------------------------------------------------------
30:
31: ------------------------------------------------------------------------
32: -- The SELECT statement in this procedure returns the Person Ids for

Line 123: from per_assignments_f paaf,

119: select distinct paaf.assignment_id,
120: paa.assignment_action_id,
121: pay_core_utils.get_parameter('ARCHIVE_ACTION_ID', ppa.legislative_parameters) archive_action_id,
122: pay_core_utils.get_parameter('LEGAL_ENTITY_ID', ppa2.legislative_parameters) legal_entity_id
123: from per_assignments_f paaf,
124: per_people_f papf,
125: pay_payroll_actions ppa, -- report payroll action
126: pay_payroll_actions ppa2, -- archive payroll action
127: pay_assignment_actions paa