APPS.PAY_CN_BAL_UPLOAD dependencies on PER_ASSIGNMENTS_F

Line 50: FROM per_assignments_f ASS

46: SELECT NVL(ADD_MONTHS(fnd_date.canonical_to_date(HOI.ORG_INFORMATION11)
47: ,12*(floor(months_between(p_upload_date
48: ,fnd_date.canonical_to_date(HOI.ORG_INFORMATION11))/12)))
49: ,END_OF_TIME)
50: FROM per_assignments_f ASS
51: ,hr_organization_information HOI
52: WHERE ASS.assignment_id = p_assignment_id
53: AND p_upload_date BETWEEN ASS.effective_start_date
54: AND ASS.effective_end_date

Line 65: FROM per_assignments_f ASS

61: CURSOR csr_tax_year( p_assignment_id NUMBER
62: , p_upload_date DATE
63: ) IS
64: SELECT TRUNC(p_upload_date,'Y')
65: FROM per_assignments_f ASS
66: WHERE ASS.assignment_id = p_assignment_id
67: AND p_upload_date BETWEEN ASS.effective_start_date AND ASS.effective_end_date;
68:
69: -- Change for bug 3041205 ends

Line 79: FROM per_assignments_f ASS

75: SELECT NVL(ADD_MONTHS(fnd_date.canonical_to_date(HOI.ORG_INFORMATION11)
76: , 3*(FLOOR(MONTHS_BETWEEN(p_upload_date
77: , fnd_date.canonical_to_date(HOI.ORG_INFORMATION11))/3)))
78: , END_OF_TIME)
79: FROM per_assignments_f ASS
80: ,hr_organization_information HOI
81: WHERE ASS.assignment_id = p_assignment_id
82: AND p_upload_date BETWEEN ASS.effective_start_date AND ASS.effective_end_date
83: AND HOI.organization_id = ASS.business_group_id

Line 92: ,per_assignments_f ASS

88: , p_upload_date DATE
89: ) IS
90: SELECT NVL(PTP.start_date, END_OF_TIME)
91: FROM per_time_periods PTP
92: ,per_assignments_f ASS
93: WHERE ASS.assignment_id = p_assignment_id
94: AND p_upload_date BETWEEN ASS.effective_start_date AND ASS.effective_end_date
95: AND PTP.payroll_id = ASS.payroll_id
96: AND p_upload_date BETWEEN PTP.start_date AND PTP.end_date;

Line 103: FROM per_assignments_f ASG

99: CURSOR csr_ele_ltd_start( p_assignment_id NUMBER
100: , p_upload_date DATE
101: ) IS
102: SELECT NVL(MIN(ASG.effective_start_date), END_OF_TIME)
103: FROM per_assignments_f ASG
104: WHERE ASG.assignment_id = p_assignment_id
105: AND ASG.effective_start_date <= p_upload_date;
106:
107: CURSOR csr_asg_start_date( p_assignment_id NUMBER

Line 112: FROM per_assignments_f ASS

108: , p_upload_date DATE
109: , p_expiry_date DATE
110: ) IS
111: SELECT NVL(GREATEST(MIN(ASS.effective_start_date), p_expiry_date),END_OF_TIME)
112: FROM per_assignments_f ASS
113: WHERE ASS.assignment_id = p_assignment_id
114: AND ASS.effective_start_date <= p_upload_date
115: AND ASS.effective_end_date >= p_expiry_date;
116: