eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PAY_IN_TAX_UTILS dependencies on PER_ALL_ASSIGNMENTS_F

Line 217: per_all_assignments_f paa

213: cursor c_metro_status
214: is
215: select pad.add_information16
216: from per_addresses pad,
217: per_all_assignments_f paa
218: where paa.assignment_id = p_assignment_id
219: and pad.person_id = paa.person_id
220: and pad.primary_flag = 'Y'
221: and pad.style = 'IN'

Line 790: ( p_assignment_id in per_all_assignments_f.assignment_id%type,

786: -- IN : --
787: -- --
788: --------------------------------------------------------------------------
789: PROCEDURE get_monthly_max_assact
790: ( p_assignment_id in per_all_assignments_f.assignment_id%type,
791: p_year_start in date ,
792: p_year_end in date ,
793: p_assact_tbl out nocopy t_assact,
794: p_eff_date_tbl out nocopy t_eff_date)

Line 1007: ( p_assignment_id in per_all_assignments_f.assignment_id%type,

1003: -- IN : --
1004: -- --
1005: --------------------------------------------------------------------------
1006: PROCEDURE get_hra_bal_information
1007: ( p_assignment_id in per_all_assignments_f.assignment_id%type,
1008: p_year_start in date ,
1009: p_year_end in date ,
1010: p_hra_tbl out nocopy t_bal_value,
1011: p_hra_sal_tbl out nocopy t_bal_value,

Line 1111: l_assignment_id per_all_assignments_f.assignment_id%type ;

1107: => Also taxable HRA will be recalculated for the entire tax year in the last month of
1108: of the tax year or termination date
1109: ****/
1110:
1111: l_assignment_id per_all_assignments_f.assignment_id%type ;
1112: l_asg_end_date DATE ;
1113: l_last_period_num NUMBER ;
1114: l_payroll_id pay_all_payrolls_f.payroll_id%type;
1115: l_current_month_rent NUMBER ;

Line 1149: CURSOR csr_get_current_gre( p_assignment_id per_all_assignments_f.assignment_id%type)

1145: l_check_date DATE;
1146: l_terminate_date DATE;
1147: l_last_month DATE;
1148:
1149: CURSOR csr_get_current_gre( p_assignment_id per_all_assignments_f.assignment_id%type)
1150: IS
1151: SELECT scl.segment1
1152: FROM hr_soft_coding_keyflex scl
1153: ,per_all_assignments_f paf

Line 1153: ,per_all_assignments_f paf

1149: CURSOR csr_get_current_gre( p_assignment_id per_all_assignments_f.assignment_id%type)
1150: IS
1151: SELECT scl.segment1
1152: FROM hr_soft_coding_keyflex scl
1153: ,per_all_assignments_f paf
1154: WHERE paf.assignment_id=p_assignment_id
1155: AND paf.SOFT_CODING_KEYFLEX_ID=scl.SOFT_CODING_KEYFLEX_ID
1156: AND p_effective_date BETWEEN paf.effective_start_date AND paf.effective_end_date;
1157:

Line 1158: CURSOR csr_get_date( p_assignment_id per_all_assignments_f.assignment_id%type

1154: WHERE paf.assignment_id=p_assignment_id
1155: AND paf.SOFT_CODING_KEYFLEX_ID=scl.SOFT_CODING_KEYFLEX_ID
1156: AND p_effective_date BETWEEN paf.effective_start_date AND paf.effective_end_date;
1157:
1158: CURSOR csr_get_date( p_assignment_id per_all_assignments_f.assignment_id%type
1159: ,p_check_date DATE)
1160: IS
1161: SELECT scl.segment1
1162: ,paf.effective_start_date

Line 1164: per_all_assignments_f paf

1160: IS
1161: SELECT scl.segment1
1162: ,paf.effective_start_date
1163: FROM hr_soft_coding_keyflex scl,
1164: per_all_assignments_f paf
1165: WHERE paf.assignment_id=p_assignment_id
1166: AND paf.SOFT_CODING_KEYFLEX_ID=scl.SOFT_CODING_KEYFLEX_ID
1167: AND paf.effective_start_date BETWEEN p_effective_date AND p_check_date ;
1168:

Line 1231: FROM per_all_assignments_f b

1227: per_periods_of_Service pps
1228: WHERE paa.assignment_id = l_assignment_id
1229: AND paa.period_of_service_id =pps.period_of_service_id
1230: AND paa.effective_end_date = ( SELECT MAX (b.effective_end_date)
1231: FROM per_all_assignments_f b
1232: WHERE paa.assignment_id=b.assignment_id );
1233:
1234: -- get tax year start ,tax year end and assignment end date in case of terminations
1235: --

Line 1587: per_all_assignments_f paa

1583: fnd_number.canonical_to_number(nvl(ppm.pem_information24,0)), -- Exemption under 80ccd
1584: fnd_number.canonical_to_number(nvl(ppm.pem_information25,0)), -- CGHS Exemption under 80D
1585: ppm.end_date
1586: from per_previous_employers ppm,
1587: per_all_assignments_f paa
1588: where paa.assignment_id = p_assignment_id
1589: and paa.person_id = ppm.person_id
1590: and p_date_earned between paa.effective_start_date and paa.effective_end_date;
1591:

Line 1781: per_all_assignments_f paa

1777:
1778: select people.per_information7
1779: into l_res_status
1780: from per_all_people_f people,
1781: per_all_assignments_f paa
1782: where people.person_id = paa.person_id
1783: and paa.assignment_id= p_assignment_id
1784: and p_effective_date between paa.effective_start_date and paa.effective_end_date
1785: and p_effective_date between people.effective_start_date and people.effective_end_date;

Line 1880: per_all_assignments_f paa

1876:
1877: Cursor c_disab_details is
1878: select pdf.category,pdf.degree,pdf.dis_information1
1879: from per_disabilities_f pdf,
1880: per_all_assignments_f paa
1881: where paa.assignment_id = p_assignment_id
1882: and paa.person_id = pdf.person_id
1883: and p_date_earned between paa.effective_start_date and paa.effective_end_date
1884: and p_date_earned between pdf.effective_start_date and pdf.effective_end_date

Line 1946: per_all_assignments_f paa

1942:
1943: Cursor c_dob is
1944: select pap.date_of_birth
1945: from per_all_people_f pap,
1946: per_all_assignments_f paa
1947: where paa.assignment_id = p_assignment_id
1948: and pap.person_id = paa.person_id
1949: and p_date_earned between paa.effective_start_date and paa.effective_end_date
1950: and p_date_earned between pap.effective_start_date and pap.effective_end_date;

Line 2626: per_all_assignments_f paa

2622: ,p_assignment_id NUMBER)
2623: IS
2624: SELECT sum(nvl(ppm.pem_information8,0))
2625: FROM per_previous_employers ppm,
2626: per_all_assignments_f paa
2627: WHERE paa.assignment_id = p_assignment_id
2628: AND p_date_earned BETWEEN paa.effective_start_date AND paa.effective_end_date
2629: AND paa.person_id =ppm.person_id
2630: AND ppm.end_date BETWEEN p_start_date and p_end_date;

Line 3232: FROM per_all_assignments_f asg

3228: l_le_asg_start DATE;
3229:
3230: CURSOR csr_asg_start IS
3231: SELECT MAX(asg.effective_end_date) + 1
3232: FROM per_all_assignments_f asg
3233: , hr_soft_coding_keyflex scl
3234: WHERE asg.soft_coding_keyflex_id = scl.soft_coding_keyflex_id
3235: AND nvl(scl.segment1,'-1')<> TO_CHAR(p_tax_unit_id)
3236: AND asg.assignment_id = p_assignment_id

Line 3242: from per_all_assignments_f asg

3238:
3239: CURSOR csr_asg_start_le
3240: IS
3241: select min(asg.effective_start_date)
3242: from per_all_assignments_f asg
3243: , hr_soft_coding_keyflex scl
3244: WHERE asg.soft_coding_keyflex_id = scl.soft_coding_keyflex_id
3245: AND scl.segment1 = TO_CHAR(p_tax_unit_id)
3246: AND asg.assignment_id = p_assignment_id

Line 3318: FROM per_all_assignments_f asg

3314: l_le_asg_end DATE;
3315:
3316: CURSOR csr_asg_end IS
3317: SELECT MIN(asg.effective_start_date) -1
3318: FROM per_all_assignments_f asg
3319: , hr_soft_coding_keyflex scl
3320: WHERE asg.soft_coding_keyflex_id = scl.soft_coding_keyflex_id
3321: AND NVL(scl.segment1,'-1')<> TO_CHAR(p_tax_unit_id)
3322: AND asg.assignment_id = p_assignment_id

Line 3328: from per_all_assignments_f asg

3324:
3325: CURSOR csr_asg_end_le
3326: IS
3327: select max(asg.effective_end_date)
3328: from per_all_assignments_f asg
3329: , hr_soft_coding_keyflex scl
3330: WHERE asg.soft_coding_keyflex_id = scl.soft_coding_keyflex_id
3331: AND scl.segment1 = TO_CHAR(p_tax_unit_id)
3332: AND asg.assignment_id = p_assignment_id

Line 3570: per_all_assignments_f asg,

3566:
3567: -- Start of Bug 11821281
3568: SELECT pep.per_information4 INTO l_pan
3569: FROM per_all_people_f pep,
3570: per_all_assignments_f asg,
3571: per_periods_of_service pos
3572: WHERE asg.assignment_id = p_assignment_id
3573: AND asg.person_id = pep.person_id
3574: AND pos.person_id = asg.person_id

Line 3972: per_all_assignments_f asg,

3968:
3969: -- Start of Bug 11821281
3970: SELECT pep.per_information4 INTO l_pan
3971: FROM per_all_people_f pep,
3972: per_all_assignments_f asg,
3973: per_periods_of_service pos
3974: WHERE asg.assignment_id = p_assignment_id
3975: AND asg.person_id = pep.person_id
3976: AND pos.person_id = asg.person_id

Line 4516: per_all_assignments_f paa

4512: CURSOR c_prev_emp_details is
4513: SELECT NVL(ppm.pem_information22,0), -- Medical Reimbursement
4514: ppm.end_date
4515: FROM per_previous_employers ppm,
4516: per_all_assignments_f paa
4517: WHERE paa.assignment_id = p_assignment_id
4518: AND paa.person_id = ppm.person_id
4519: AND p_date_earned BETWEEN paa.effective_start_date AND paa.effective_end_date;
4520: