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 92: per_all_assignments_f paa

88: cursor c_metro_status
89: is
90: select pad.add_information16
91: from per_addresses pad,
92: per_all_assignments_f paa
93: where paa.assignment_id = p_assignment_id
94: and pad.person_id = paa.person_id
95: and pad.primary_flag = 'Y'
96: and pad.style = 'IN'

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

475: -- IN : --
476: -- --
477: --------------------------------------------------------------------------
478: PROCEDURE get_monthly_max_assact
479: ( p_assignment_id in per_all_assignments_f.assignment_id%type,
480: p_year_start in date ,
481: p_year_end in date ,
482: p_assact_tbl out nocopy t_assact,
483: p_eff_date_tbl out nocopy t_eff_date)

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

692: -- IN : --
693: -- --
694: --------------------------------------------------------------------------
695: PROCEDURE get_hra_bal_information
696: ( p_assignment_id in per_all_assignments_f.assignment_id%type,
697: p_year_start in date ,
698: p_year_end in date ,
699: p_hra_tbl out nocopy t_bal_value,
700: p_hra_sal_tbl out nocopy t_bal_value,

Line 797: l_assignment_id per_all_assignments_f.assignment_id%type ;

793: calcualte taxable hra only for current month.
794: => But if there is any date track update on the House Rent Information element then
795: => we need to recalculate the taxable amount for HRA for the entire tax year.
796: ****/
797: l_assignment_id per_all_assignments_f.assignment_id%type ;
798: l_asg_end_date DATE ;
799: l_last_period_num NUMBER ;
800: l_payroll_id pay_all_payrolls_f.payroll_id%type;
801: l_current_month_rent NUMBER ;

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

828: l_entry_end_date DATE;
829: l_check_date DATE;
830:
831:
832: CURSOR csr_get_current_gre( p_assignment_id per_all_assignments_f.assignment_id%type)
833: IS
834: SELECT scl.segment1
835: FROM hr_soft_coding_keyflex scl
836: ,per_all_assignments_f paf

Line 836: ,per_all_assignments_f paf

832: CURSOR csr_get_current_gre( p_assignment_id per_all_assignments_f.assignment_id%type)
833: IS
834: SELECT scl.segment1
835: FROM hr_soft_coding_keyflex scl
836: ,per_all_assignments_f paf
837: WHERE paf.assignment_id=p_assignment_id
838: AND paf.SOFT_CODING_KEYFLEX_ID=scl.SOFT_CODING_KEYFLEX_ID
839: AND p_effective_date BETWEEN paf.effective_start_date AND paf.effective_end_date;
840:

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

837: WHERE paf.assignment_id=p_assignment_id
838: AND paf.SOFT_CODING_KEYFLEX_ID=scl.SOFT_CODING_KEYFLEX_ID
839: AND p_effective_date BETWEEN paf.effective_start_date AND paf.effective_end_date;
840:
841: CURSOR csr_get_date( p_assignment_id per_all_assignments_f.assignment_id%type
842: ,p_check_date DATE)
843: IS
844: SELECT scl.segment1
845: ,paf.effective_start_date

Line 847: per_all_assignments_f paf

843: IS
844: SELECT scl.segment1
845: ,paf.effective_start_date
846: FROM hr_soft_coding_keyflex scl,
847: per_all_assignments_f paf
848: WHERE paf.assignment_id=p_assignment_id
849: AND paf.SOFT_CODING_KEYFLEX_ID=scl.SOFT_CODING_KEYFLEX_ID
850: AND paf.effective_start_date BETWEEN p_effective_date AND p_check_date ;
851:

Line 904: FROM per_all_assignments_f b

900: per_periods_of_Service pps
901: WHERE paa.assignment_id = l_assignment_id
902: AND paa.period_of_service_id =pps.period_of_service_id
903: AND paa.effective_end_date = ( SELECT MAX (b.effective_end_date)
904: FROM per_all_assignments_f b
905: WHERE paa.assignment_id=b.assignment_id );
906:
907: -- get tax year start ,tax year end and assignment end date in case of terminations
908: --

Line 1230: per_all_assignments_f paa

1226: fnd_number.canonical_to_number(nvl(ppm.pem_information23,0)), -- Sec and HE Cess
1227: fnd_number.canonical_to_number(nvl(ppm.pem_information24,0)), -- Exemption under 80ccd
1228: ppm.end_date
1229: from per_previous_employers ppm,
1230: per_all_assignments_f paa
1231: where paa.assignment_id = p_assignment_id
1232: and paa.person_id = ppm.person_id
1233: and p_date_earned between paa.effective_start_date and paa.effective_end_date;
1234:

Line 1469: per_all_assignments_f paa

1465:
1466: Cursor c_disab_details is
1467: select pdf.category,pdf.degree,pdf.dis_information1
1468: from per_disabilities_f pdf,
1469: per_all_assignments_f paa
1470: where paa.assignment_id = p_assignment_id
1471: and paa.person_id = pdf.person_id
1472: and p_date_earned between paa.effective_start_date and paa.effective_end_date
1473: and p_date_earned between pdf.effective_start_date and pdf.effective_end_date

Line 1535: per_all_assignments_f paa

1531:
1532: Cursor c_dob is
1533: select pap.date_of_birth
1534: from per_all_people_f pap,
1535: per_all_assignments_f paa
1536: where paa.assignment_id = p_assignment_id
1537: and pap.person_id = paa.person_id
1538: and p_date_earned between paa.effective_start_date and paa.effective_end_date
1539: and p_date_earned between pap.effective_start_date and pap.effective_end_date;

Line 2191: per_all_assignments_f paa

2187: ,p_assignment_id NUMBER)
2188: IS
2189: SELECT sum(nvl(ppm.pem_information8,0))
2190: FROM per_previous_employers ppm,
2191: per_all_assignments_f paa
2192: WHERE paa.assignment_id = p_assignment_id
2193: AND p_date_earned BETWEEN paa.effective_start_date AND paa.effective_end_date
2194: AND paa.person_id =ppm.person_id
2195: AND ppm.end_date BETWEEN p_start_date and p_end_date;

Line 2796: FROM per_all_assignments_f asg

2792: l_le_asg_start DATE;
2793:
2794: CURSOR csr_asg_start IS
2795: SELECT MAX(asg.effective_end_date) + 1
2796: FROM per_all_assignments_f asg
2797: , hr_soft_coding_keyflex scl
2798: WHERE asg.soft_coding_keyflex_id = scl.soft_coding_keyflex_id
2799: AND nvl(scl.segment1,'-1')<> TO_CHAR(p_tax_unit_id)
2800: AND asg.assignment_id = p_assignment_id

Line 2806: from per_all_assignments_f asg

2802:
2803: CURSOR csr_asg_start_le
2804: IS
2805: select min(asg.effective_start_date)
2806: from per_all_assignments_f asg
2807: , hr_soft_coding_keyflex scl
2808: WHERE asg.soft_coding_keyflex_id = scl.soft_coding_keyflex_id
2809: AND scl.segment1 = TO_CHAR(p_tax_unit_id)
2810: AND asg.assignment_id = p_assignment_id

Line 2882: FROM per_all_assignments_f asg

2878: l_le_asg_end DATE;
2879:
2880: CURSOR csr_asg_end IS
2881: SELECT MIN(asg.effective_start_date) -1
2882: FROM per_all_assignments_f asg
2883: , hr_soft_coding_keyflex scl
2884: WHERE asg.soft_coding_keyflex_id = scl.soft_coding_keyflex_id
2885: AND NVL(scl.segment1,'-1')<> TO_CHAR(p_tax_unit_id)
2886: AND asg.assignment_id = p_assignment_id

Line 2892: from per_all_assignments_f asg

2888:
2889: CURSOR csr_asg_end_le
2890: IS
2891: select max(asg.effective_end_date)
2892: from per_all_assignments_f asg
2893: , hr_soft_coding_keyflex scl
2894: WHERE asg.soft_coding_keyflex_id = scl.soft_coding_keyflex_id
2895: AND scl.segment1 = TO_CHAR(p_tax_unit_id)
2896: AND asg.assignment_id = p_assignment_id

Line 3463: per_all_assignments_f paa

3459: CURSOR c_prev_emp_details is
3460: SELECT NVL(ppm.pem_information22,0), -- Medical Reimbursement
3461: ppm.end_date
3462: FROM per_previous_employers ppm,
3463: per_all_assignments_f paa
3464: WHERE paa.assignment_id = p_assignment_id
3465: AND paa.person_id = ppm.person_id
3466: AND p_date_earned BETWEEN paa.effective_start_date AND paa.effective_end_date;
3467: