DBA Data[Home] [Help]

APPS.PAY_NL_BAL_UPLOAD dependencies on PER_ASSIGNMENTS_F

Line 71: per_time_periods ptp, per_assignments_f ass

67: ) is
68: select
69: nvl(ptp.start_date, END_OF_TIME)
70: from
71: per_time_periods ptp, per_assignments_f ass
72: where
73: ass.assignment_id = p_assignment_id
74: and
75: ptp.payroll_id = ass.payroll_id

Line 90: per_assignments_f ass

86: ) is
87: select
88: nvl(min(ass.effective_start_date), END_OF_TIME)
89: from
90: per_assignments_f ass
91: where
92: ass.assignment_id = p_assignment_id
93: and
94: ass.payroll_id is not null

Line 186: per_assignments_f

182: business_group_id
183: into
184: l_business_group_id
185: from
186: per_assignments_f
187: where
188: assignment_id = p_assignment_id;
189: l_expiry_date := hr_gbbal.dimension_reset_date
190: (