APPS.PAY_SG_BAL_UPLOAD dependencies on PER_ASSIGNMENTS_F

Line 90: from per_assignments_f ASS

86: select nvl(add_months(fnd_date.canonical_to_date(HOI.ORG_INFORMATION11),
87: 12*(floor(months_between(p_upload_date,
88: fnd_date.canonical_to_date(HOI.ORG_INFORMATION11))/12))),
89: END_OF_TIME)
90: from per_assignments_f ASS
91: ,hr_organization_information HOI
92: where ASS.assignment_id = p_assignment_id
93: and p_upload_date between ASS.effective_start_date
94: and ASS.effective_end_date

Line 109: from per_assignments_f ASS

105: select nvl(add_months(fnd_date.canonical_to_date(HOI.ORG_INFORMATION11),
106: 3*(floor(months_between(p_upload_date,
107: fnd_date.canonical_to_date(HOI.ORG_INFORMATION11))/3))),
108: END_OF_TIME)
109: from per_assignments_f ASS
110: ,hr_organization_information HOI
111: where ASS.assignment_id = p_assignment_id
112: and p_upload_date between ASS.effective_start_date
113: and ASS.effective_end_date

Line 126: ,per_assignments_f ASS

122: ,p_upload_date date
123: ) is
124: select nvl(PTP.start_date, END_OF_TIME)
125: from per_time_periods PTP
126: ,per_assignments_f ASS
127: where ASS.assignment_id = p_assignment_id
128: and p_upload_date between ASS.effective_start_date
129: and ASS.effective_end_date
130: and PTP.payroll_id = ASS.payroll_id

Line 142: from per_assignments_f ASG

138: p_assignment_id number
139: ,p_upload_date date
140: ) is
141: select nvl(min(ASG.effective_start_date), END_OF_TIME)
142: from per_assignments_f ASG
143: where ASG.assignment_id = p_assignment_id
144: and ASG.effective_start_date <= p_upload_date;
145: --
146: --

Line 154: from per_assignments_f ASS

150: ,p_expiry_date date
151: ) is
152: select nvl(greatest(min(ASS.effective_start_date), p_expiry_date),
153: END_OF_TIME)
154: from per_assignments_f ASS
155: where ASS.assignment_id = p_assignment_id
156: and ASS.effective_start_date <= p_upload_date
157: and ASS.effective_end_date >= p_expiry_date;
158: --