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_DECLARATION dependencies on PER_ASSIGNMENTS_F

Line 75: , per_assignments_f assign

71: , fnd_date.canonical_to_date(org.org_information2) locking_period_start
72: , TRUNC(SYSDATE - start_date) hire_duration
73: FROM hr_organization_information org
74: , per_people_f person
75: , per_assignments_f assign
76: , hr_soft_coding_keyflex scl
77: WHERE org.org_information_context = 'PER_IN_TAX_DECL_DETAILS'
78: AND person.person_id = c_person_id
79: AND assign.person_id = person.person_id

Line 188: l_assignment_id per_assignments_f.assignment_id%TYPE;

184: --
185: l_procedure VARCHAR(100);
186: l_message VARCHAR2(250);
187: l_effective_date DATE;
188: l_assignment_id per_assignments_f.assignment_id%TYPE;
189: l_extra_info_id per_assignment_extra_info.assignment_extra_info_id%TYPE;
190: --
191: BEGIN
192: --

Line 404: -- IN : p_assignment_id per_assignments_f.assignment_id --

400: -- the flag stating if the employee tax declaration --
401: -- details have been approved or not. . --
402: -- --
403: -- Parameters : --
404: -- IN : p_assignment_id per_assignments_f.assignment_id --
405: -- p_tax_year VARCHAR2 --
406: -- p_extra_info_id assignment_extra_info_id --
407: -- RETURN : VARCHAR2 --
408: -- --

Line 416: (p_assignment_id IN per_assignments_f.assignment_id%TYPE

412: --------------------------------------------------------------------------
413: -- 1.0 24-Sep-2004 PUCHIL Initial Version --
414: --------------------------------------------------------------------------
415: FUNCTION get_approval_status
416: (p_assignment_id IN per_assignments_f.assignment_id%TYPE
417: ,p_tax_year IN VARCHAR2
418: ,p_extra_info_id OUT NOCOPY per_assignment_extra_info.assignment_extra_info_id%TYPE)
419: RETURN VARCHAR2
420: IS

Line 551: -- IN : p_assignment_id per_assignments_f.assignment_id%TYPE--

547: -- entries's input value on a date which is before the --
548: -- freeze date for the financial year. --
549: -- --
550: -- Parameters : --
551: -- IN : p_assignment_id per_assignments_f.assignment_id%TYPE--
552: -- p_actual_value VARCHAR2 --
553: -- p_ele_entry_id element_entry_id%TYPE --
554: -- p_input_value_id input_value_id%TYPE --
555: -- RETURN : VARCHAR2 --

Line 564: (p_assignment_id IN per_assignments_f.assignment_id%TYPE

560: --------------------------------------------------------------------------
561: -- 1.0 24-Sep-2004 PUCHIL Initial Version --
562: --------------------------------------------------------------------------
563: FUNCTION get_planned_value
564: (p_assignment_id IN per_assignments_f.assignment_id%TYPE
565: ,p_actual_value IN VARCHAR2
566: ,p_ele_entry_id IN pay_element_entries_f.element_entry_id%TYPE
567: ,p_input_value_id IN pay_input_values_f.input_value_id%TYPE)
568: RETURN VARCHAR2

Line 689: FROM per_assignments_f assgn

685: SELECT types.element_name
686: , inputs.name name
687: , value.screen_entry_value planned
688: , value.screen_entry_value actual
689: FROM per_assignments_f assgn
690: , pay_element_links_f link
691: , pay_element_types_f types
692: , pay_element_entries_f entries
693: , pay_element_entry_values_f value

Line 992: , per_assignments_f assgn

988: IS
989: SELECT MAX(entries.last_update_date)
990: FROM pay_element_types_f ele
991: , pay_element_entries_f entries
992: , per_assignments_f assgn
993: WHERE ele.element_name in (c_element_name1
994: ,c_element_name2
995: ,c_element_name3
996: ,c_element_name4

Line 1191: (p_assignment_id IN per_assignments_f.assignment_id%TYPE

1187:
1188:
1189:
1190: PROCEDURE get_entry_details
1191: (p_assignment_id IN per_assignments_f.assignment_id%TYPE
1192: ,p_element_name IN pay_element_types_f.element_name%TYPE
1193: ,p_effective_date IN DATE
1194: ,p_element_type_id OUT NOCOPY pay_element_types_f.element_type_id%TYPE
1195: ,p_element_link_id OUT NOCOPY pay_element_links_f.element_link_id%TYPE

Line 1206: ,c_assignment_id IN per_assignments_f.assignment_id%TYPE)

1202: IS
1203: --
1204: CURSOR csr_element_entry
1205: (c_element_link_id IN pay_element_links_f.element_link_id%TYPE
1206: ,c_assignment_id IN per_assignments_f.assignment_id%TYPE)
1207: IS
1208: SELECT entries.element_entry_id
1209: , links.element_type_id
1210: , links.business_group_id

Line 1401: -- IN : p_assignment_id per_assignments_f.assignment_id%TYPE--

1397: -- Description : The procedure is responsible for storing the detials--
1398: -- in 'House Rent Information' element. --
1399: -- --
1400: -- Parameters : --
1401: -- IN : p_assignment_id per_assignments_f.assignment_id%TYPE--
1402: -- p_apr NUMBER --
1403: -- p_may NUMBER --
1404: -- p_jun NUMBER --
1405: -- p_jul NUMBER --

Line 1424: (p_assignment_id IN per_assignments_f.assignment_id%TYPE

1420: --------------------------------------------------------------------------
1421: -- 1.0 24-Sep-2004 PUCHIL Initial Version --
1422: --------------------------------------------------------------------------
1423: PROCEDURE declare_house_rent
1424: (p_assignment_id IN per_assignments_f.assignment_id%TYPE
1425: ,p_apr IN NUMBER
1426: ,p_may IN NUMBER
1427: ,p_jun IN NUMBER
1428: ,p_jul IN NUMBER

Line 1666: -- IN : p_assignment_id per_assignments_f.assignment_id%TYPE--

1662: -- disability 80u and then stores the detials in the --
1663: -- 'Deductions under Chapter VI A' element. --
1664: -- --
1665: -- Parameters : --
1666: -- IN : p_assignment_id per_assignments_f.assignment_id%TYPE--
1667: -- p_pension_fund_80ccc NUMBER --
1668: -- p_medical_insurance_prem_80d NUMBER --
1669: -- p_sec_80ddb_senior_citizen VARCHAR2 --
1670: -- p_disease_treatment_80ddb NUMBER --

Line 1687: (p_assignment_id IN per_assignments_f.assignment_id%TYPE

1683: --------------------------------------------------------------------------
1684: -- 1.0 24-Sep-2004 PUCHIL Initial Version --
1685: --------------------------------------------------------------------------
1686: PROCEDURE declare_chapter6a
1687: (p_assignment_id IN per_assignments_f.assignment_id%TYPE
1688: ,p_pension_fund_80ccc IN NUMBER
1689: ,p_medical_insurance_prem_80d IN NUMBER
1690: ,p_sec_80ddb_senior_citizen IN VARCHAR2
1691: ,p_disease_treatment_80ddb IN NUMBER

Line 2020: -- IN : p_assignment_id per_assignments_f.assignment_id%TYPE--

2016: -- Description : The procedure is responsible for storing the detials--
2017: -- in 'Rebates under Section 88' element. --
2018: -- --
2019: -- Parameters : --
2020: -- IN : p_assignment_id per_assignments_f.assignment_id%TYPE--
2021: -- p_public_provident_fund NUMBER --
2022: -- p_post_office_savings_scheme NUMBER --
2023: -- p_deposit_in_nsc_vi_issue NUMBER --
2024: -- p_deposit_in_nsc_viii_issue NUMBER --

Line 2046: (p_assignment_id IN per_assignments_f.assignment_id%TYPE

2042: -- 1.0 24-Sep-2004 PUCHIL Initial Version --
2043: -- 1.1 25-Apr-2005 VGSRINIV Nulled out for stat update(Bug 4251141)--
2044: --------------------------------------------------------------------------
2045: PROCEDURE declare_section88
2046: (p_assignment_id IN per_assignments_f.assignment_id%TYPE
2047: ,p_deferred_annuity IN NUMBER
2048: ,p_senior_citizen_sav_scheme IN NUMBER
2049: ,p_public_provident_fund IN NUMBER
2050: ,p_post_office_savings_scheme IN NUMBER

Line 2130: -- IN : p_assignment_id per_assignments_f.assignment_id%TYPE--

2126: -- Description : The procedure is responsible for storing the --
2127: -- detials in 'Other Income' element. --
2128: -- --
2129: -- Parameters : --
2130: -- IN : p_assignment_id per_assignments_f.assignment_id%TYPE--
2131: -- p_income_from_house_property NUMBER --
2132: -- p_profit_and_gain_from_busines NUMBER --
2133: -- p_long_term_capital_gain NUMBER --
2134: -- p_short_term_capital_gain NUMBER --

Line 2147: (p_assignment_id IN per_assignments_f.assignment_id%TYPE

2143: --------------------------------------------------------------------------
2144: -- 1.0 24-Sep-2004 PUCHIL Initial Version --
2145: --------------------------------------------------------------------------
2146: PROCEDURE declare_other_income
2147: (p_assignment_id IN per_assignments_f.assignment_id%TYPE
2148: ,p_income_from_house_property IN NUMBER
2149: ,p_profit_and_gain_from_busines IN NUMBER
2150: ,p_long_term_capital_gain IN NUMBER
2151: ,p_short_term_capital_gain IN NUMBER

Line 2342: -- IN : p_assignment_id per_assignments_f.assignment_id%TYPE--

2338: -- Description : The procedure is responsible for storing the --
2339: -- detials in 'Deduction under Section 80DD' element. --
2340: -- --
2341: -- Parameters : --
2342: -- IN : p_assignment_id per_assignments_f.assignment_id%TYPE--
2343: -- p_disability_type VARCHAR2 --
2344: -- p_disability_percentage VARCHAR2 --
2345: -- p_treatment_amount NUMBER --
2346: -- p_effective_date DATE --

Line 2357: (p_assignment_id IN per_assignments_f.assignment_id%TYPE

2353: --------------------------------------------------------------------------
2354: -- 1.0 24-Sep-2004 PUCHIL Initial Version --
2355: --------------------------------------------------------------------------
2356: PROCEDURE declare_section80dd
2357: (p_assignment_id IN per_assignments_f.assignment_id%TYPE
2358: ,p_disability_type IN VARCHAR2
2359: ,p_disability_percentage IN VARCHAR2
2360: ,p_treatment_amount IN NUMBER
2361: ,p_effective_date IN DATE default null

Line 2390: (c_assignment_id IN per_assignments_f.assignment_id%TYPE

2386: AND element_name = p_element_name
2387: AND p_effective_date BETWEEN effective_start_date AND effective_end_date;
2388:
2389: CURSOR csr_element_link_details
2390: (c_assignment_id IN per_assignments_f.assignment_id%TYPE
2391: ,c_effective_date IN DATE
2392: ,c_element_link_id IN NUMBER)
2393: IS
2394: SELECT types.element_type_id

Line 2397: FROM per_assignments_f assgn

2393: IS
2394: SELECT types.element_type_id
2395: , links.element_link_id
2396: , assgn.business_group_id
2397: FROM per_assignments_f assgn
2398: , pay_element_links_f links
2399: , pay_element_types_f types
2400: WHERE assgn.assignment_id = c_assignment_id
2401: AND links.element_link_id = c_element_link_id

Line 2421: , per_assignments_f assgn

2417: SELECT entries.element_type_id
2418: , entries.object_version_number
2419: , assgn.business_group_id
2420: FROM pay_element_entries_f entries
2421: , per_assignments_f assgn
2422: WHERE entries.element_entry_id = c_element_entry_id
2423: AND entries.assignment_id = assgn.assignment_id
2424: AND c_effective_date BETWEEN entries.effective_start_date
2425: AND entries.effective_end_date

Line 2628: -- IN : p_assignment_id per_assignments_f.assignment_id%TYPE--

2624: -- Description : The procedure is responsible for storing the --
2625: -- detials in 'Deduction under Section 80G' element. --
2626: -- --
2627: -- Parameters : --
2628: -- IN : p_assignment_id per_assignments_f.assignment_id%TYPE--
2629: -- p_donation_type VARCHAR2 --
2630: -- p_donation_amount NUMBER --
2631: -- p_effective_date DATE --
2632: -- p_element_entry_id element_entry_id%TYPE --

Line 2642: (p_assignment_id IN per_assignments_f.assignment_id%TYPE

2638: --------------------------------------------------------------------------
2639: -- 1.0 24-Sep-2004 PUCHIL Initial Version --
2640: --------------------------------------------------------------------------
2641: PROCEDURE declare_section80g
2642: (p_assignment_id IN per_assignments_f.assignment_id%TYPE
2643: ,p_donation_type IN VARCHAR2
2644: ,p_donation_amount IN NUMBER
2645: ,p_effective_date IN DATE default null
2646: ,p_element_entry_id IN pay_element_entries_f.element_entry_id%TYPE default null

Line 2675: (c_assignment_id IN per_assignments_f.assignment_id%TYPE

2671: AND element_name = p_element_name
2672: AND p_effective_date BETWEEN effective_start_date AND effective_end_date;
2673:
2674: CURSOR csr_element_link_details
2675: (c_assignment_id IN per_assignments_f.assignment_id%TYPE
2676: ,c_effective_date IN DATE
2677: ,c_element_link_id IN NUMBER)
2678: IS
2679: SELECT types.element_type_id

Line 2682: FROM per_assignments_f assgn

2678: IS
2679: SELECT types.element_type_id
2680: , link.element_link_id
2681: , assgn.business_group_id
2682: FROM per_assignments_f assgn
2683: , pay_element_links_f link
2684: , pay_element_types_f types
2685: WHERE assgn.assignment_id = c_assignment_id
2686: AND link.element_link_id = c_element_link_id

Line 2706: , per_assignments_f assgn

2702: SELECT entries.element_type_id
2703: , entries.object_version_number
2704: , assgn.business_group_id
2705: FROM pay_element_entries_f entries
2706: , per_assignments_f assgn
2707: WHERE entries.element_entry_id = c_element_entry_id
2708: AND entries.assignment_id = assgn.assignment_id
2709: AND c_effective_date BETWEEN entries.effective_start_date
2710: AND entries.effective_end_date

Line 2908: -- IN : p_assignment_id per_assignments_f.assignment_id%TYPE--

2904: -- Description : The procedure is responsible for storing the --
2905: -- detials in 'Life Insurance Premium' element. --
2906: -- --
2907: -- Parameters : --
2908: -- IN : p_assignment_id per_assignments_f.assignment_id%TYPE--
2909: -- p_premium_paid VARCHAR2 --
2910: -- p_sum_assured NUMBER --
2911: -- p_effective_date DATE --
2912: -- p_element_entry_id element_entry_id%TYPE --

Line 2922: (p_assignment_id IN per_assignments_f.assignment_id%TYPE

2918: --------------------------------------------------------------------------
2919: -- 1.0 24-Sep-2004 PUCHIL Initial Version --
2920: --------------------------------------------------------------------------
2921: PROCEDURE declare_life_insurance_premium
2922: (p_assignment_id IN per_assignments_f.assignment_id%TYPE
2923: ,p_premium_paid IN VARCHAR2
2924: ,p_sum_assured IN NUMBER
2925: ,p_effective_date IN DATE default null
2926: ,p_element_entry_id IN pay_element_entries_f.element_entry_id%TYPE default null

Line 2944: (c_assignment_id IN per_assignments_f.assignment_id%TYPE

2940: l_effective_start_date DATE;
2941: l_effective_end_date DATE;
2942: --
2943: CURSOR csr_element_link_details
2944: (c_assignment_id IN per_assignments_f.assignment_id%TYPE
2945: ,c_effective_date IN DATE
2946: ,c_element_link_id IN NUMBER)
2947: IS
2948: SELECT types.element_type_id

Line 2951: FROM per_assignments_f assgn

2947: IS
2948: SELECT types.element_type_id
2949: , link.element_link_id
2950: , assgn.business_group_id
2951: FROM per_assignments_f assgn
2952: , pay_element_links_f link
2953: , pay_element_types_f types
2954: WHERE assgn.assignment_id = c_assignment_id
2955: AND link.element_link_id = c_element_link_id

Line 2975: , per_assignments_f assgn

2971: SELECT entries.element_type_id
2972: , entries.object_version_number
2973: , assgn.business_group_id
2974: FROM pay_element_entries_f entries
2975: , per_assignments_f assgn
2976: WHERE entries.element_entry_id = c_element_entry_id
2977: AND entries.assignment_id = assgn.assignment_id
2978: AND c_effective_date BETWEEN entries.effective_start_date
2979: AND entries.effective_end_date

Line 3182: -- IN : p_assignment_id per_assignments_f.assignment_id%TYPE--

3178: -- Description : The procedure is responsible for storing the --
3179: -- detials in 'Tuition Fee' element. --
3180: -- --
3181: -- Parameters : --
3182: -- IN : p_assignment_id per_assignments_f.assignment_id%TYPE--
3183: -- p_tuition_fee_for_child_1 NUMBER --
3184: -- p_tuition_fee_for_child_2 NUMBER --
3185: -- p_effective_date DATE --
3186: -- p_element_entry_id element_entry_id%TYPE --

Line 3197: (p_assignment_id IN per_assignments_f.assignment_id%TYPE

3193: -- 1.0 24-Sep-2004 PUCHIL Initial Version --
3194: -- 1.1 25-Apr-2005 VGSRINIV Nulled out for Stat Update(Bug 4251141)--
3195: --------------------------------------------------------------------------
3196: PROCEDURE declare_tuition_fee
3197: (p_assignment_id IN per_assignments_f.assignment_id%TYPE
3198: ,p_tuition_fee_for_child_1 IN NUMBER
3199: ,p_tuition_fee_for_child_2 IN NUMBER
3200: ,p_effective_date IN DATE DEFAULT NULL
3201: ,p_warnings OUT NOCOPY BOOLEAN)

Line 3255: -- IN : p_assignment_id per_assignments_f.assignment_id%TYPE--

3251: -- Description : The procedure is responsible for storing the --
3252: -- detials in 'Deduction under Section 80CCE' element. --
3253: -- --
3254: -- Parameters : --
3255: -- IN : p_assignment_id per_assignments_f.assignment_id%TYPE--
3256: -- p_investment_type VARCHAR2 --
3257: -- p_investment_amount NUMBER --
3258: -- p_effective_date DATE --
3259: -- p_element_entry_id element_entry_id%TYPE --

Line 3270: (p_assignment_id IN per_assignments_f.assignment_id%TYPE

3266: -- 1.0 14-Apr-2005 VGSRINIV Initial Version --
3267: --------------------------------------------------------------------------
3268:
3269: PROCEDURE declare_section80cce
3270: (p_assignment_id IN per_assignments_f.assignment_id%TYPE
3271: ,p_investment_type IN VARCHAR2
3272: ,p_investment_amount IN NUMBER
3273: ,p_effective_date IN DATE default null
3274: ,p_element_entry_id IN pay_element_entries_f.element_entry_id%TYPE DEFAULT NULL

Line 3297: (c_assignment_id IN per_assignments_f.assignment_id%TYPE

3293: l_element_name pay_element_types_f.element_name%TYPE;
3294: l_token1 VARCHAR2(240);
3295: --
3296: CURSOR csr_element_link_details
3297: (c_assignment_id IN per_assignments_f.assignment_id%TYPE
3298: ,c_effective_date IN DATE
3299: ,c_element_name IN pay_element_types_f.element_name%TYPE)
3300: IS
3301: SELECT types.element_type_id

Line 3304: FROM per_assignments_f assgn

3300: IS
3301: SELECT types.element_type_id
3302: , link.element_link_id
3303: , assgn.business_group_id
3304: FROM per_assignments_f assgn
3305: , pay_element_links_f link
3306: , pay_element_types_f types
3307: WHERE assgn.assignment_id = c_assignment_id
3308: AND link.element_link_id = pay_in_utils.get_element_link_id(c_assignment_id

Line 3331: , per_assignments_f assgn

3327: SELECT entries.element_type_id
3328: , entries.object_version_number
3329: , assgn.business_group_id
3330: FROM pay_element_entries_f entries
3331: , per_assignments_f assgn
3332: WHERE entries.element_entry_id = c_element_entry_id
3333: AND entries.assignment_id = assgn.assignment_id
3334: AND c_effective_date BETWEEN entries.effective_start_date
3335: AND entries.effective_end_date

Line 3345: FROM per_assignments_f assgn

3341: IS
3342: SELECT entries.element_entry_id entry_id
3343: ,entries.object_version_number
3344: ,value2.screen_entry_value
3345: FROM per_assignments_f assgn
3346: , pay_element_links_f link
3347: , pay_element_types_f types
3348: , pay_element_entries_f entries
3349: , pay_element_entry_values_f value1

Line 3645: -- IN : p_assignment_id per_assignments_f.assignment_id%TYPE--

3641: -- Description : The procedure is responsible for storing the --
3642: -- detials in 'Deduction under Section 80GG' element. --
3643: -- --
3644: -- Parameters : --
3645: -- IN : p_assignment_id per_assignments_f.assignment_id%TYPE--
3646: -- p_effective_date DATE --
3647: -- p_claim_exemp_under_sec_80gg VARCHAR2 --
3648: -- OUT : p_warnings BOOLEAN --
3649: -- --

Line 3658: (p_assignment_id IN per_assignments_f.assignment_id%TYPE

3654: -- 1.0 14-Apr-2005 VGSRINIV Initial Version --
3655: --------------------------------------------------------------------------
3656:
3657: PROCEDURE declare_section80gg
3658: (p_assignment_id IN per_assignments_f.assignment_id%TYPE
3659: ,p_effective_date IN DATE DEFAULT NULL
3660: ,p_claim_exemp_under_sec_80gg IN VARCHAR2
3661: ,p_warnings OUT NOCOPY BOOLEAN)
3662: IS

Line 3823: -- IN : p_assignment_id per_assignments_f.assignment_id%TYPE--

3819: -- Description : The procedure is responsible for storing the --
3820: -- detials in 'Deduction under Section 80E' element. --
3821: -- --
3822: -- Parameters : --
3823: -- IN : p_assignment_id per_assignments_f.assignment_id%TYPE--
3824: -- p_effective_date DATE --
3825: -- p_higher_education_loan_80e NUMBER --
3826: -- OUT : p_warnings BOOLEAN --
3827: -- --

Line 3836: (p_assignment_id IN per_assignments_f.assignment_id%TYPE

3832: -- 1.0 14-Apr-2005 VGSRINIV Initial Version --
3833: --------------------------------------------------------------------------
3834:
3835: PROCEDURE declare_section80e
3836: (p_assignment_id IN per_assignments_f.assignment_id%TYPE
3837: ,p_effective_date IN DATE DEFAULT NULL
3838: ,p_higher_education_loan_80e IN NUMBER DEFAULT NULL
3839: ,p_warnings OUT NOCOPY BOOLEAN)
3840: IS

Line 4013: -- IN : p_assignment_id per_assignments_f.assignment_id%TYPE--

4009: -- Description : The procedure is responsible for storing the --
4010: -- detials in 'Deduction under Section 80GGA' element. --
4011: -- --
4012: -- Parameters : --
4013: -- IN : p_assignment_id per_assignments_f.assignment_id%TYPE--
4014: -- p_effective_date DATE --
4015: -- p_donation_for_research_80gga NUMBER --
4016: -- OUT : p_warnings BOOLEAN --
4017: -- --

Line 4026: (p_assignment_id IN per_assignments_f.assignment_id%TYPE

4022: -- 1.0 14-Apr-2005 VGSRINIV Initial Version --
4023: --------------------------------------------------------------------------
4024:
4025: PROCEDURE declare_section80gga
4026: (p_assignment_id IN per_assignments_f.assignment_id%TYPE
4027: ,p_effective_date IN DATE DEFAULT NULL
4028: ,p_donation_for_research_80gga IN NUMBER DEFAULT NULL
4029: ,p_warnings OUT NOCOPY BOOLEAN)
4030: IS

Line 4202: -- IN : p_assignment_id per_assignments_f.assignment_id%TYPE--

4198: -- Description : The procedure is responsible for storing the --
4199: -- detials in 'Deduction under Section 80D' element. --
4200: -- --
4201: -- Parameters : --
4202: -- IN : p_assignment_id per_assignments_f.assignment_id%TYPE--
4203: -- p_effective_date DATE --
4204: -- p_medical_insurance_prem_80d NUMBER --
4205: -- p_sec_80d_senior_citizen VARCHAR2 --
4206: -- OUT : p_warnings BOOLEAN --

Line 4216: (p_assignment_id IN per_assignments_f.assignment_id%TYPE

4212: -- 1.0 14-Apr-2005 VGSRINIV Initial Version --
4213: --------------------------------------------------------------------------
4214:
4215: PROCEDURE declare_section80d
4216: (p_assignment_id IN per_assignments_f.assignment_id%TYPE
4217: ,p_effective_date IN DATE DEFAULT NULL
4218: ,p_medical_insurance_prem_80d IN NUMBER DEFAULT NULL
4219: ,p_sec_80d_senior_citizen IN VARCHAR2 DEFAULT NULL
4220: ,p_med_par_insurance_prem_80d IN NUMBER DEFAULT NULL

Line 4403: -- IN : p_assignment_id per_assignments_f.assignment_id%TYPE--

4399: -- Description : The procedure is responsible for storing the --
4400: -- detials in 'Deduction under Section 80DDB' element. --
4401: -- --
4402: -- Parameters : --
4403: -- IN : p_assignment_id per_assignments_f.assignment_id%TYPE--
4404: -- p_effective_date DATE --
4405: -- p_disease_treatment_80ddb NUMBER --
4406: -- p_sec_80ddb_senior_citizen VARCHAR2 --
4407: -- OUT : p_warnings BOOLEAN --

Line 4416: (p_assignment_id IN per_assignments_f.assignment_id%TYPE

4412: --------------------------------------------------------------------------
4413: -- 1.0 14-Apr-2005 VGSRINIV Initial Version --
4414: --------------------------------------------------------------------------
4415: PROCEDURE declare_section80ddb
4416: (p_assignment_id IN per_assignments_f.assignment_id%TYPE
4417: ,p_effective_date IN DATE DEFAULT NULL
4418: ,p_disease_treatment_80ddb IN NUMBER DEFAULT NULL
4419: ,p_sec_80ddb_senior_citizen IN VARCHAR2 DEFAULT NULL
4420: ,p_warnings OUT NOCOPY BOOLEAN)

Line 4601: -- IN : p_assignment_id per_assignments_f.assignment_id%TYPE--

4597: -- Description : The procedure is responsible for storing the --
4598: -- detials in 'Deduction under Section 80U' element. --
4599: -- --
4600: -- Parameters : --
4601: -- IN : p_assignment_id per_assignments_f.assignment_id%TYPE--
4602: -- p_effective_date DATE --
4603: -- OUT : p_warnings BOOLEAN --
4604: -- --
4605: -- Change History : --

Line 4613: (p_assignment_id IN per_assignments_f.assignment_id%TYPE

4609: -- 1.0 14-Apr-2005 VGSRINIV Initial Version --
4610: --------------------------------------------------------------------------
4611:
4612: PROCEDURE declare_section80U
4613: (p_assignment_id IN per_assignments_f.assignment_id%TYPE
4614: ,p_effective_date IN DATE DEFAULT NULL
4615: ,p_warnings OUT NOCOPY BOOLEAN)
4616: IS
4617:

Line 4717: (p_assignment_id IN per_assignments_f.assignment_id%TYPE

4713:
4714: /* BUG 4251141: STAT UPDATE 2005 CHANGES END HERE */
4715:
4716: PROCEDURE declare_tax
4717: (p_assignment_id IN per_assignments_f.assignment_id%TYPE
4718: ,p_is_monthly_rent_changed IN VARCHAR2
4719: ,p_apr IN NUMBER default null
4720: ,p_may IN NUMBER default null
4721: ,p_jun IN NUMBER default null

Line 5229: -- IN :p_assignment_id per_assignments_f.assignment_id%TYPE--

5225: -- Description : The procedure is responsible for approval of --
5226: -- tax declaration for the assignment in question. --
5227: -- --
5228: -- Parameters : --
5229: -- IN :p_assignment_id per_assignments_f.assignment_id%TYPE--
5230: -- p_approval_flag VARCHAR2 --
5231: -- p_effective_date DATE --
5232: -- p_comment_text VARCHAR2 --
5233: -- Change History : --

Line 5240: (p_assignment_id IN per_assignments_f.assignment_id%TYPE

5236: --------------------------------------------------------------------------
5237: -- 1.0 24-Sep-2004 PUCHIL Initial Version --
5238: --------------------------------------------------------------------------
5239: PROCEDURE approve_declaration
5240: (p_assignment_id IN per_assignments_f.assignment_id%TYPE
5241: ,p_approval_flag IN VARCHAR2
5242: ,p_effective_date IN DATE
5243: ,p_comment_text IN VARCHAR2)
5244: IS

Line 5342: -- IN : p_assignment_id per_assignments_f.assignment_id%TYPE--

5338: -- Description : The procedure is responsible for storing the --
5339: -- details through WEB ADI . --
5340: -- --
5341: -- Parameters : --
5342: -- IN : p_assignment_id per_assignments_f.assignment_id%TYPE--
5343: -- p_effective_date DATE --
5344: -- p_warnings BOOLEAN --
5345: -- --
5346: -- Change History : --

Line 5515: (c_assignment_id IN per_assignments_f.assignment_id%TYPE

5511: AND element_name = p_element_name
5512: AND p_effective_date BETWEEN effective_start_date AND effective_end_date;
5513:
5514: CURSOR csr_number_of_entries
5515: (c_assignment_id IN per_assignments_f.assignment_id%TYPE
5516: ,c_element_name IN pay_element_types_f.element_name%TYPE
5517: ,c_effective_date IN DATE
5518: ,c_element_link_id IN NUMBER)
5519: IS

Line 5521: FROM per_assignments_f assgn

5517: ,c_effective_date IN DATE
5518: ,c_element_link_id IN NUMBER)
5519: IS
5520: SELECT count(entries.element_entry_id)
5521: FROM per_assignments_f assgn
5522: , pay_element_links_f link
5523: , pay_element_types_f types
5524: , pay_element_entries_f entries
5525: WHERE assgn.assignment_id = c_assignment_id

Line 6250: FROM per_assignments_f assgn

6246: SELECT entries.element_entry_id entry_id
6247: , value1.screen_entry_value Disability_Type
6248: , value2.screen_entry_value Treatment_Amount
6249: , value3.screen_entry_value Disability_Percentage
6250: FROM per_assignments_f assgn
6251: , pay_element_links_f link
6252: , pay_element_types_f types
6253: , pay_element_entries_f entries
6254: , pay_element_entry_values_f value1

Line 6307: FROM per_assignments_f assgn

6303: IS
6304: SELECT entries.element_entry_id entry_id
6305: , value1.screen_entry_value Donation_Type
6306: , value2.screen_entry_value Donation_Amount
6307: FROM per_assignments_f assgn
6308: , pay_element_links_f link
6309: , pay_element_types_f types
6310: , pay_element_entries_f entries
6311: , pay_element_entry_values_f value1

Line 6354: FROM per_assignments_f assgn

6350: IS
6351: SELECT entries.element_entry_id entry_id
6352: , value1.screen_entry_value Premium_Paid
6353: , value2.screen_entry_value Sum_Assured
6354: FROM per_assignments_f assgn
6355: , pay_element_links_f link
6356: , pay_element_types_f types
6357: , pay_element_entries_f entries
6358: , pay_element_entry_values_f value1

Line 6403: FROM per_assignments_f assgn

6399: IS
6400: SELECT entries.element_entry_id entry_id
6401: , value1.screen_entry_value Investment_Amount
6402: , value2.screen_entry_value Component_Name
6403: FROM per_assignments_f assgn
6404: , pay_element_links_f link
6405: , pay_element_types_f types
6406: , pay_element_entries_f entries
6407: , pay_element_entry_values_f value1