APPS.PAY_HK_BAL_UPLOAD dependencies on PER_ASSIGNMENTS_F

Line 78: from per_assignments_f ASS

74: select nvl(add_months(fnd_date.canonical_to_date(HOI.ORG_INFORMATION11),
75: 12*(floor(months_between(p_upload_date,
76: fnd_date.canonical_to_date(HOI.ORG_INFORMATION11))/12))),
77: END_OF_TIME)
78: from per_assignments_f ASS
79: ,hr_organization_information HOI
80: where ASS.assignment_id = p_assignment_id
81: and p_upload_date between ASS.effective_start_date
82: and ASS.effective_end_date

Line 97: from per_assignments_f ASS

93: SELECT to_date('01-04-'||to_char(fnd_number.canonical_to_number(
94: to_char(p_upload_date,'YYYY'))+ decode(sign(p_upload_date
95: - to_date('01-04-'||to_char(p_upload_date,'YYYY'),'DD-MM-YYYY'))
96: ,-1,-1,0)),'DD-MM-YYYY')
97: from per_assignments_f ASS
98: where ASS.assignment_id = p_assignment_id
99: and p_upload_date between ASS.effective_start_date
100: and ASS.effective_end_date;
101: --

Line 113: from per_assignments_f ASS

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

Line 130: ,per_assignments_f ASS

126: ,p_upload_date date
127: ) is
128: select nvl(PTP.start_date, END_OF_TIME)
129: from per_time_periods PTP
130: ,per_assignments_f ASS
131: where ASS.assignment_id = p_assignment_id
132: and p_upload_date between ASS.effective_start_date
133: and ASS.effective_end_date
134: and PTP.payroll_id = ASS.payroll_id

Line 146: from per_assignments_f ASG

142: p_assignment_id number
143: ,p_upload_date date
144: ) is
145: select nvl(min(ASG.effective_start_date), END_OF_TIME)
146: from per_assignments_f ASG
147: where ASG.assignment_id = p_assignment_id
148: and ASG.effective_start_date <= p_upload_date;
149: --
150: --

Line 158: from per_assignments_f ASS

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