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 76: , per_assignments_f assign

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

Line 189: l_assignment_id per_assignments_f.assignment_id%TYPE;

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

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

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

Line 417: (p_assignment_id IN per_assignments_f.assignment_id%TYPE

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

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

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

Line 565: (p_assignment_id IN per_assignments_f.assignment_id%TYPE

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

Line 690: FROM per_assignments_f assgn

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

Line 998: , per_assignments_f assgn

994: IS
995: SELECT MAX(entries.last_update_date)
996: FROM pay_element_types_f ele
997: , pay_element_entries_f entries
998: , per_assignments_f assgn
999: WHERE ele.element_name in (c_element_name1
1000: ,c_element_name2
1001: ,c_element_name3
1002: ,c_element_name4

Line 1205: (p_assignment_id IN per_assignments_f.assignment_id%TYPE

1201:
1202:
1203:
1204: PROCEDURE get_entry_details
1205: (p_assignment_id IN per_assignments_f.assignment_id%TYPE
1206: ,p_element_name IN pay_element_types_f.element_name%TYPE
1207: ,p_effective_date IN DATE
1208: ,p_element_type_id OUT NOCOPY pay_element_types_f.element_type_id%TYPE
1209: ,p_element_link_id OUT NOCOPY pay_element_links_f.element_link_id%TYPE

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

1216: IS
1217: --
1218: CURSOR csr_element_entry
1219: (c_element_link_id IN pay_element_links_f.element_link_id%TYPE
1220: ,c_assignment_id IN per_assignments_f.assignment_id%TYPE)
1221: IS
1222: SELECT entries.element_entry_id
1223: , links.element_type_id
1224: , links.business_group_id

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

1411: -- Description : The procedure is responsible for storing the detials--
1412: -- in 'House Rent Information' element. --
1413: -- --
1414: -- Parameters : --
1415: -- IN : p_assignment_id per_assignments_f.assignment_id%TYPE--
1416: -- p_apr NUMBER --
1417: -- p_may NUMBER --
1418: -- p_jun NUMBER --
1419: -- p_jul NUMBER --

Line 1438: (p_assignment_id IN per_assignments_f.assignment_id%TYPE

1434: --------------------------------------------------------------------------
1435: -- 1.0 24-Sep-2004 PUCHIL Initial Version --
1436: --------------------------------------------------------------------------
1437: PROCEDURE declare_house_rent
1438: (p_assignment_id IN per_assignments_f.assignment_id%TYPE
1439: ,p_apr IN NUMBER
1440: ,p_may IN NUMBER
1441: ,p_jun IN NUMBER
1442: ,p_jul IN NUMBER

Line 1539: per_assignments_f where assignment_id = p_assignment_id

1535: l_effective_date := pay_in_utils.get_effective_date(p_effective_date);
1536: l_delete_entries := 'N';
1537: --
1538: select min(effective_start_date) into l_assgn_start_date from
1539: per_assignments_f where assignment_id = p_assignment_id
1540: and payroll_id is not null; /* bug: 16341134 */
1541: --
1542: get_entry_details(p_assignment_id => p_assignment_id
1543: ,p_element_name => 'House Rent Information'

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

1834: -- disability 80u and then stores the detials in the --
1835: -- 'Deductions under Chapter VI A' element. --
1836: -- --
1837: -- Parameters : --
1838: -- IN : p_assignment_id per_assignments_f.assignment_id%TYPE--
1839: -- p_pension_fund_80ccc NUMBER --
1840: -- p_medical_insurance_prem_80d NUMBER --
1841: -- p_sec_80ddb_senior_citizen VARCHAR2 --
1842: -- p_disease_treatment_80ddb NUMBER --

Line 1859: (p_assignment_id IN per_assignments_f.assignment_id%TYPE

1855: --------------------------------------------------------------------------
1856: -- 1.0 24-Sep-2004 PUCHIL Initial Version --
1857: --------------------------------------------------------------------------
1858: PROCEDURE declare_chapter6a
1859: (p_assignment_id IN per_assignments_f.assignment_id%TYPE
1860: ,p_pension_fund_80ccc IN NUMBER
1861: ,p_medical_insurance_prem_80d IN NUMBER
1862: ,p_sec_80ddb_senior_citizen IN VARCHAR2
1863: ,p_disease_treatment_80ddb IN NUMBER

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

2188: -- Description : The procedure is responsible for storing the detials--
2189: -- in 'Rebates under Section 88' element. --
2190: -- --
2191: -- Parameters : --
2192: -- IN : p_assignment_id per_assignments_f.assignment_id%TYPE--
2193: -- p_public_provident_fund NUMBER --
2194: -- p_post_office_savings_scheme NUMBER --
2195: -- p_deposit_in_nsc_vi_issue NUMBER --
2196: -- p_deposit_in_nsc_viii_issue NUMBER --

Line 2218: (p_assignment_id IN per_assignments_f.assignment_id%TYPE

2214: -- 1.0 24-Sep-2004 PUCHIL Initial Version --
2215: -- 1.1 25-Apr-2005 VGSRINIV Nulled out for stat update(Bug 4251141)--
2216: --------------------------------------------------------------------------
2217: PROCEDURE declare_section88
2218: (p_assignment_id IN per_assignments_f.assignment_id%TYPE
2219: ,p_deferred_annuity IN NUMBER
2220: ,p_senior_citizen_sav_scheme IN NUMBER
2221: ,p_public_provident_fund IN NUMBER
2222: ,p_post_office_savings_scheme IN NUMBER

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

2298: -- Description : The procedure is responsible for storing the --
2299: -- detials in 'Other Income' element. --
2300: -- --
2301: -- Parameters : --
2302: -- IN : p_assignment_id per_assignments_f.assignment_id%TYPE--
2303: -- p_income_from_house_property NUMBER --
2304: -- p_profit_and_gain_from_busines NUMBER --
2305: -- p_long_term_capital_gain NUMBER --
2306: -- p_short_term_capital_gain NUMBER --

Line 2319: (p_assignment_id IN per_assignments_f.assignment_id%TYPE

2315: --------------------------------------------------------------------------
2316: -- 1.0 24-Sep-2004 PUCHIL Initial Version --
2317: --------------------------------------------------------------------------
2318: PROCEDURE declare_other_income
2319: (p_assignment_id IN per_assignments_f.assignment_id%TYPE
2320: ,p_income_from_house_property IN NUMBER
2321: ,p_profit_and_gain_from_busines IN NUMBER
2322: ,p_long_term_capital_gain IN NUMBER
2323: ,p_short_term_capital_gain IN NUMBER

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

2516: -- Description : The procedure is responsible for storing the --
2517: -- detials in 'Deduction under Section 80DD' element. --
2518: -- --
2519: -- Parameters : --
2520: -- IN : p_assignment_id per_assignments_f.assignment_id%TYPE--
2521: -- p_disability_type VARCHAR2 --
2522: -- p_disability_percentage VARCHAR2 --
2523: -- p_treatment_amount NUMBER --
2524: -- p_effective_date DATE --

Line 2535: (p_assignment_id IN per_assignments_f.assignment_id%TYPE

2531: --------------------------------------------------------------------------
2532: -- 1.0 24-Sep-2004 PUCHIL Initial Version --
2533: --------------------------------------------------------------------------
2534: PROCEDURE declare_section80dd
2535: (p_assignment_id IN per_assignments_f.assignment_id%TYPE
2536: ,p_disability_type IN VARCHAR2
2537: ,p_disability_percentage IN VARCHAR2
2538: ,p_treatment_amount IN NUMBER
2539: ,p_effective_date IN DATE default null

Line 2568: (c_assignment_id IN per_assignments_f.assignment_id%TYPE

2564: AND element_name = p_element_name
2565: AND p_effective_date BETWEEN effective_start_date AND effective_end_date;
2566:
2567: CURSOR csr_element_link_details
2568: (c_assignment_id IN per_assignments_f.assignment_id%TYPE
2569: ,c_effective_date IN DATE
2570: ,c_element_link_id IN NUMBER)
2571: IS
2572: SELECT types.element_type_id

Line 2575: FROM per_assignments_f assgn

2571: IS
2572: SELECT types.element_type_id
2573: , links.element_link_id
2574: , assgn.business_group_id
2575: FROM per_assignments_f assgn
2576: , pay_element_links_f links
2577: , pay_element_types_f types
2578: WHERE assgn.assignment_id = c_assignment_id
2579: AND links.element_link_id = c_element_link_id

Line 2599: , per_assignments_f assgn

2595: SELECT entries.element_type_id
2596: , entries.object_version_number
2597: , assgn.business_group_id
2598: FROM pay_element_entries_f entries
2599: , per_assignments_f assgn
2600: WHERE entries.element_entry_id = c_element_entry_id
2601: AND entries.assignment_id = assgn.assignment_id
2602: AND c_effective_date BETWEEN entries.effective_start_date
2603: AND entries.effective_end_date

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

2802: -- Description : The procedure is responsible for storing the --
2803: -- detials in 'Deduction under Section 80G' element. --
2804: -- --
2805: -- Parameters : --
2806: -- IN : p_assignment_id per_assignments_f.assignment_id%TYPE--
2807: -- p_donation_type VARCHAR2 --
2808: -- p_donation_amount NUMBER --
2809: -- p_effective_date DATE --
2810: -- p_element_entry_id element_entry_id%TYPE --

Line 2820: (p_assignment_id IN per_assignments_f.assignment_id%TYPE

2816: --------------------------------------------------------------------------
2817: -- 1.0 24-Sep-2004 PUCHIL Initial Version --
2818: --------------------------------------------------------------------------
2819: PROCEDURE declare_section80g
2820: (p_assignment_id IN per_assignments_f.assignment_id%TYPE
2821: ,p_donation_type IN VARCHAR2
2822: ,p_donation_amount IN NUMBER
2823: ,p_effective_date IN DATE default null
2824: ,p_element_entry_id IN pay_element_entries_f.element_entry_id%TYPE default null

Line 2853: (c_assignment_id IN per_assignments_f.assignment_id%TYPE

2849: AND element_name = p_element_name
2850: AND p_effective_date BETWEEN effective_start_date AND effective_end_date;
2851:
2852: CURSOR csr_element_link_details
2853: (c_assignment_id IN per_assignments_f.assignment_id%TYPE
2854: ,c_effective_date IN DATE
2855: ,c_element_link_id IN NUMBER)
2856: IS
2857: SELECT types.element_type_id

Line 2860: FROM per_assignments_f assgn

2856: IS
2857: SELECT types.element_type_id
2858: , link.element_link_id
2859: , assgn.business_group_id
2860: FROM per_assignments_f assgn
2861: , pay_element_links_f link
2862: , pay_element_types_f types
2863: WHERE assgn.assignment_id = c_assignment_id
2864: AND link.element_link_id = c_element_link_id

Line 2884: , per_assignments_f assgn

2880: SELECT entries.element_type_id
2881: , entries.object_version_number
2882: , assgn.business_group_id
2883: FROM pay_element_entries_f entries
2884: , per_assignments_f assgn
2885: WHERE entries.element_entry_id = c_element_entry_id
2886: AND entries.assignment_id = assgn.assignment_id
2887: AND c_effective_date BETWEEN entries.effective_start_date
2888: AND entries.effective_end_date

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

3082: -- Description : The procedure is responsible for storing the --
3083: -- detials in 'Life Insurance Premium' element. --
3084: -- --
3085: -- Parameters : --
3086: -- IN : p_assignment_id per_assignments_f.assignment_id%TYPE--
3087: -- p_premium_paid VARCHAR2 --
3088: -- p_sum_assured NUMBER --
3089: -- p_effective_date DATE --
3090: -- p_element_entry_id element_entry_id%TYPE --

Line 3101: (p_assignment_id IN per_assignments_f.assignment_id%TYPE

3097: -- 1.0 24-Sep-2004 PUCHIL Initial Version --
3098: -- 1.1 02-Feb-2010 MDUBASI Added LIC Policy Number
3099: --------------------------------------------------------------------------
3100: PROCEDURE declare_life_insurance_premium
3101: (p_assignment_id IN per_assignments_f.assignment_id%TYPE
3102: ,p_premium_paid IN VARCHAR2
3103: ,p_sum_assured IN NUMBER
3104: ,p_effective_date IN DATE default null
3105: ,p_element_entry_id IN pay_element_entries_f.element_entry_id%TYPE default null

Line 3125: (c_assignment_id IN per_assignments_f.assignment_id%TYPE

3121: l_effective_start_date DATE;
3122: l_effective_end_date DATE;
3123: --
3124: CURSOR csr_element_link_details
3125: (c_assignment_id IN per_assignments_f.assignment_id%TYPE
3126: ,c_effective_date IN DATE
3127: ,c_element_link_id IN NUMBER)
3128: IS
3129: SELECT types.element_type_id

Line 3132: FROM per_assignments_f assgn

3128: IS
3129: SELECT types.element_type_id
3130: , link.element_link_id
3131: , assgn.business_group_id
3132: FROM per_assignments_f assgn
3133: , pay_element_links_f link
3134: , pay_element_types_f types
3135: WHERE assgn.assignment_id = c_assignment_id
3136: AND link.element_link_id = c_element_link_id

Line 3156: , per_assignments_f assgn

3152: SELECT entries.element_type_id
3153: , entries.object_version_number
3154: , assgn.business_group_id
3155: FROM pay_element_entries_f entries
3156: , per_assignments_f assgn
3157: WHERE entries.element_entry_id = c_element_entry_id
3158: AND entries.assignment_id = assgn.assignment_id
3159: AND c_effective_date BETWEEN entries.effective_start_date
3160: AND entries.effective_end_date

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

3376: -- Description : The procedure is responsible for storing the --
3377: -- detials in 'PF Information' element. --
3378: -- --
3379: -- Parameters : --
3380: -- IN : p_assignment_id per_assignments_f.assignment_id%TYPE--
3381: -- p_effective_date DATE --
3382: -- p_ee_vol_pf_amount NUMBER --
3383: -- p_ee_vol_pf_percent NUMBER --
3384: -- OUT : p_warnings BOOLEAN --

Line 3394: (p_assignment_id IN per_assignments_f.assignment_id%TYPE

3390: -- 1.0 02-Feb-2010 mdubasi Initial Version --
3391: --------------------------------------------------------------------------
3392:
3393: PROCEDURE declare_vpf
3394: (p_assignment_id IN per_assignments_f.assignment_id%TYPE
3395: ,p_effective_date IN DATE DEFAULT NULL
3396: ,p_ee_vol_pf_amount IN NUMBER
3397: ,p_ee_vol_pf_percent IN NUMBER
3398: ,p_warnings OUT NOCOPY BOOLEAN)

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

3565: -- Description : The procedure is responsible for storing the --
3566: -- detials in 'Tuition Fee' element. --
3567: -- --
3568: -- Parameters : --
3569: -- IN : p_assignment_id per_assignments_f.assignment_id%TYPE--
3570: -- p_tuition_fee_for_child_1 NUMBER --
3571: -- p_tuition_fee_for_child_2 NUMBER --
3572: -- p_effective_date DATE --
3573: -- p_element_entry_id element_entry_id%TYPE --

Line 3584: (p_assignment_id IN per_assignments_f.assignment_id%TYPE

3580: -- 1.0 24-Sep-2004 PUCHIL Initial Version --
3581: -- 1.1 25-Apr-2005 VGSRINIV Nulled out for Stat Update(Bug 4251141)--
3582: --------------------------------------------------------------------------
3583: PROCEDURE declare_tuition_fee
3584: (p_assignment_id IN per_assignments_f.assignment_id%TYPE
3585: ,p_tuition_fee_for_child_1 IN NUMBER
3586: ,p_tuition_fee_for_child_2 IN NUMBER
3587: ,p_effective_date IN DATE DEFAULT NULL
3588: ,p_warnings OUT NOCOPY BOOLEAN)

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

3638: -- Description : The procedure is responsible for storing the --
3639: -- detials in 'Deduction under Section 80CCE' element. --
3640: -- --
3641: -- Parameters : --
3642: -- IN : p_assignment_id per_assignments_f.assignment_id%TYPE--
3643: -- p_investment_type VARCHAR2 --
3644: -- p_investment_amount NUMBER --
3645: -- p_effective_date DATE --
3646: -- p_element_entry_id element_entry_id%TYPE --

Line 3657: (p_assignment_id IN per_assignments_f.assignment_id%TYPE

3653: -- 1.0 14-Apr-2005 VGSRINIV Initial Version --
3654: --------------------------------------------------------------------------
3655:
3656: PROCEDURE declare_section80cce
3657: (p_assignment_id IN per_assignments_f.assignment_id%TYPE
3658: ,p_investment_type IN VARCHAR2
3659: ,p_investment_amount IN NUMBER
3660: ,p_effective_date IN DATE default null
3661: ,p_element_entry_id IN pay_element_entries_f.element_entry_id%TYPE DEFAULT NULL

Line 3684: (c_assignment_id IN per_assignments_f.assignment_id%TYPE

3680: l_element_name pay_element_types_f.element_name%TYPE;
3681: l_token1 VARCHAR2(240);
3682: --
3683: CURSOR csr_element_link_details
3684: (c_assignment_id IN per_assignments_f.assignment_id%TYPE
3685: ,c_effective_date IN DATE
3686: ,c_element_name IN pay_element_types_f.element_name%TYPE)
3687: IS
3688: SELECT types.element_type_id

Line 3691: FROM per_assignments_f assgn

3687: IS
3688: SELECT types.element_type_id
3689: , link.element_link_id
3690: , assgn.business_group_id
3691: FROM per_assignments_f assgn
3692: , pay_element_links_f link
3693: , pay_element_types_f types
3694: WHERE assgn.assignment_id = c_assignment_id
3695: AND link.element_link_id = pay_in_utils.get_element_link_id(c_assignment_id

Line 3718: , per_assignments_f assgn

3714: SELECT entries.element_type_id
3715: , entries.object_version_number
3716: , assgn.business_group_id
3717: FROM pay_element_entries_f entries
3718: , per_assignments_f assgn
3719: WHERE entries.element_entry_id = c_element_entry_id
3720: AND entries.assignment_id = assgn.assignment_id
3721: AND c_effective_date BETWEEN entries.effective_start_date
3722: AND entries.effective_end_date

Line 3732: FROM per_assignments_f assgn

3728: IS
3729: SELECT entries.element_entry_id entry_id
3730: ,entries.object_version_number
3731: ,value2.screen_entry_value
3732: FROM per_assignments_f assgn
3733: , pay_element_links_f link
3734: , pay_element_types_f types
3735: , pay_element_entries_f entries
3736: , pay_element_entry_values_f value1

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

4028: -- Description : The procedure is responsible for storing the --
4029: -- detials in 'Deduction under Section 80GG' element. --
4030: -- --
4031: -- Parameters : --
4032: -- IN : p_assignment_id per_assignments_f.assignment_id%TYPE--
4033: -- p_effective_date DATE --
4034: -- p_claim_exemp_under_sec_80gg VARCHAR2 --
4035: -- OUT : p_warnings BOOLEAN --
4036: -- --

Line 4045: (p_assignment_id IN per_assignments_f.assignment_id%TYPE

4041: -- 1.0 14-Apr-2005 VGSRINIV Initial Version --
4042: --------------------------------------------------------------------------
4043:
4044: PROCEDURE declare_section80gg
4045: (p_assignment_id IN per_assignments_f.assignment_id%TYPE
4046: ,p_effective_date IN DATE DEFAULT NULL
4047: ,p_claim_exemp_under_sec_80gg IN VARCHAR2
4048: ,p_warnings OUT NOCOPY BOOLEAN)
4049: IS

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

4206: -- Description : The procedure is responsible for storing the --
4207: -- detials in 'Deduction under Section 80E' element. --
4208: -- --
4209: -- Parameters : --
4210: -- IN : p_assignment_id per_assignments_f.assignment_id%TYPE--
4211: -- p_effective_date DATE --
4212: -- p_higher_education_loan_80e NUMBER --
4213: -- OUT : p_warnings BOOLEAN --
4214: -- --

Line 4223: (p_assignment_id IN per_assignments_f.assignment_id%TYPE

4219: -- 1.0 14-Apr-2005 VGSRINIV Initial Version --
4220: --------------------------------------------------------------------------
4221:
4222: PROCEDURE declare_section80e
4223: (p_assignment_id IN per_assignments_f.assignment_id%TYPE
4224: ,p_effective_date IN DATE DEFAULT NULL
4225: ,p_higher_education_loan_80e IN NUMBER DEFAULT NULL
4226: ,p_warnings OUT NOCOPY BOOLEAN)
4227: IS

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

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

Line 4415: (p_assignment_id IN per_assignments_f.assignment_id%TYPE

4411: -- 1.0 11-Mar-2010 MDUBASI Initial Version --
4412: --------------------------------------------------------------------------
4413:
4414: PROCEDURE declare_section80ccf
4415: (p_assignment_id IN per_assignments_f.assignment_id%TYPE
4416: ,p_effective_date IN DATE DEFAULT NULL
4417: ,p_infrastructure_bonds_80ccf IN NUMBER DEFAULT NULL
4418: ,p_warnings OUT NOCOPY BOOLEAN)
4419: IS

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

4590: -- Description : The procedure is responsible for storing the --
4591: -- detials in 'Deduction under Section 80CCG' element. --
4592: -- --
4593: -- Parameters : --
4594: -- IN : p_assignment_id per_assignments_f.assignment_id%TYPE--
4595: -- p_effective_date DATE --
4596: -- p_investment_amt_80ccg NUMBER --
4597: -- p_investment_date_80ccg DATE --
4598: -- OUT : p_warnings BOOLEAN --

Line 4607: (p_assignment_id IN per_assignments_f.assignment_id%TYPE

4603: --------------------------------------------------------------------------
4604: -- 1.0 11-Mar-2010 MDUBASI Initial Version --
4605: --------------------------------------------------------------------------
4606: PROCEDURE declare_section80ccg
4607: (p_assignment_id IN per_assignments_f.assignment_id%TYPE
4608: ,p_effective_date IN DATE DEFAULT NULL
4609: ,p_investment_amt_80ccg IN NUMBER DEFAULT NULL
4610: ,p_investment_date_80ccg IN DATE DEFAULT NULL
4611: ,p_warnings OUT NOCOPY BOOLEAN)

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

4786: -- Description : The procedure is responsible for storing the --
4787: -- detials in 'Deduction under Section 80GGA' element. --
4788: -- --
4789: -- Parameters : --
4790: -- IN : p_assignment_id per_assignments_f.assignment_id%TYPE--
4791: -- p_effective_date DATE --
4792: -- p_donation_for_research_80gga NUMBER --
4793: -- OUT : p_warnings BOOLEAN --
4794: -- --

Line 4803: (p_assignment_id IN per_assignments_f.assignment_id%TYPE

4799: -- 1.0 14-Apr-2005 VGSRINIV Initial Version --
4800: --------------------------------------------------------------------------
4801:
4802: PROCEDURE declare_section80gga
4803: (p_assignment_id IN per_assignments_f.assignment_id%TYPE
4804: ,p_effective_date IN DATE DEFAULT NULL
4805: ,p_donation_for_research_80gga IN NUMBER DEFAULT NULL
4806: ,p_warnings OUT NOCOPY BOOLEAN)
4807: IS

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

4976: -- Description : The procedure is responsible for storing the --
4977: -- detials in 'Deduction under Section 80D' element. --
4978: -- --
4979: -- Parameters : --
4980: -- IN : p_assignment_id per_assignments_f.assignment_id%TYPE--
4981: -- p_effective_date DATE --
4982: -- p_medical_insurance_prem_80d NUMBER --
4983: -- p_sec_80d_senior_citizen VARCHAR2 --
4984: -- OUT : p_warnings BOOLEAN --

Line 4994: (p_assignment_id IN per_assignments_f.assignment_id%TYPE

4990: -- 1.0 14-Apr-2005 VGSRINIV Initial Version --
4991: --------------------------------------------------------------------------
4992:
4993: PROCEDURE declare_section80d
4994: (p_assignment_id IN per_assignments_f.assignment_id%TYPE
4995: ,p_effective_date IN DATE DEFAULT NULL
4996: ,p_medical_insurance_prem_80d IN NUMBER DEFAULT NULL
4997: ,p_sec_80d_senior_citizen IN VARCHAR2 DEFAULT NULL
4998: ,p_med_par_insurance_prem_80d IN NUMBER DEFAULT NULL

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

5189: -- Description : The procedure is responsible for storing the --
5190: -- detials in 'Deduction under Section 80DDB' element. --
5191: -- --
5192: -- Parameters : --
5193: -- IN : p_assignment_id per_assignments_f.assignment_id%TYPE--
5194: -- p_effective_date DATE --
5195: -- p_disease_treatment_80ddb NUMBER --
5196: -- p_sec_80ddb_senior_citizen VARCHAR2 --
5197: -- OUT : p_warnings BOOLEAN --

Line 5206: (p_assignment_id IN per_assignments_f.assignment_id%TYPE

5202: --------------------------------------------------------------------------
5203: -- 1.0 14-Apr-2005 VGSRINIV Initial Version --
5204: --------------------------------------------------------------------------
5205: PROCEDURE declare_section80ddb
5206: (p_assignment_id IN per_assignments_f.assignment_id%TYPE
5207: ,p_effective_date IN DATE DEFAULT NULL
5208: ,p_disease_treatment_80ddb IN NUMBER DEFAULT NULL
5209: ,p_sec_80ddb_senior_citizen IN VARCHAR2 DEFAULT NULL
5210: ,p_warnings OUT NOCOPY BOOLEAN)

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

5387: -- Description : The procedure is responsible for storing the --
5388: -- detials in 'Deduction under Section 80U' element. --
5389: -- --
5390: -- Parameters : --
5391: -- IN : p_assignment_id per_assignments_f.assignment_id%TYPE--
5392: -- p_effective_date DATE --
5393: -- OUT : p_warnings BOOLEAN --
5394: -- --
5395: -- Change History : --

Line 5403: (p_assignment_id IN per_assignments_f.assignment_id%TYPE

5399: -- 1.0 14-Apr-2005 VGSRINIV Initial Version --
5400: --------------------------------------------------------------------------
5401:
5402: PROCEDURE declare_section80U
5403: (p_assignment_id IN per_assignments_f.assignment_id%TYPE
5404: ,p_effective_date IN DATE DEFAULT NULL
5405: ,p_warnings OUT NOCOPY BOOLEAN)
5406: IS
5407:

Line 5507: (p_assignment_id IN per_assignments_f.assignment_id%TYPE

5503:
5504: /* BUG 4251141: STAT UPDATE 2005 CHANGES END HERE */
5505:
5506: PROCEDURE declare_tax
5507: (p_assignment_id IN per_assignments_f.assignment_id%TYPE
5508: ,p_is_monthly_rent_changed IN VARCHAR2
5509: ,p_apr IN NUMBER default null
5510: ,p_may IN NUMBER default null
5511: ,p_jun IN NUMBER default null

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

6005: -- Description : The procedure is responsible for approval of --
6006: -- tax declaration for the assignment in question. --
6007: -- --
6008: -- Parameters : --
6009: -- IN :p_assignment_id per_assignments_f.assignment_id%TYPE--
6010: -- p_approval_flag VARCHAR2 --
6011: -- p_effective_date DATE --
6012: -- p_comment_text VARCHAR2 --
6013: -- Change History : --

Line 6020: (p_assignment_id IN per_assignments_f.assignment_id%TYPE

6016: --------------------------------------------------------------------------
6017: -- 1.0 24-Sep-2004 PUCHIL Initial Version --
6018: --------------------------------------------------------------------------
6019: PROCEDURE approve_declaration
6020: (p_assignment_id IN per_assignments_f.assignment_id%TYPE
6021: ,p_approval_flag IN VARCHAR2
6022: ,p_effective_date IN DATE
6023: ,p_comment_text IN VARCHAR2)
6024: IS

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

6118: -- Description : The procedure is responsible for storing the --
6119: -- details through WEB ADI . --
6120: -- --
6121: -- Parameters : --
6122: -- IN : p_assignment_id per_assignments_f.assignment_id%TYPE--
6123: -- p_effective_date DATE --
6124: -- p_warnings BOOLEAN --
6125: -- --
6126: -- Change History : --

Line 6354: (c_assignment_id IN per_assignments_f.assignment_id%TYPE

6350: AND element_name = p_element_name
6351: AND p_effective_date BETWEEN effective_start_date AND effective_end_date;
6352:
6353: CURSOR csr_number_of_entries
6354: (c_assignment_id IN per_assignments_f.assignment_id%TYPE
6355: ,c_element_name IN pay_element_types_f.element_name%TYPE
6356: ,c_effective_date IN DATE
6357: ,c_element_link_id IN NUMBER)
6358: IS

Line 6360: FROM per_assignments_f assgn

6356: ,c_effective_date IN DATE
6357: ,c_element_link_id IN NUMBER)
6358: IS
6359: SELECT count(entries.element_entry_id)
6360: FROM per_assignments_f assgn
6361: , pay_element_links_f link
6362: , pay_element_types_f types
6363: , pay_element_entries_f entries
6364: WHERE assgn.assignment_id = c_assignment_id

Line 7124: FROM per_assignments_f assgn

7120: SELECT entries.element_entry_id entry_id
7121: , value1.screen_entry_value Disability_Type
7122: , value2.screen_entry_value Treatment_Amount
7123: , value3.screen_entry_value Disability_Percentage
7124: FROM per_assignments_f assgn
7125: , pay_element_links_f link
7126: , pay_element_types_f types
7127: , pay_element_entries_f entries
7128: , pay_element_entry_values_f value1

Line 7181: FROM per_assignments_f assgn

7177: IS
7178: SELECT entries.element_entry_id entry_id
7179: , value1.screen_entry_value Donation_Type
7180: , value2.screen_entry_value Donation_Amount
7181: FROM per_assignments_f assgn
7182: , pay_element_links_f link
7183: , pay_element_types_f types
7184: , pay_element_entries_f entries
7185: , pay_element_entry_values_f value1

Line 7230: FROM per_assignments_f assgn

7226: , value1.screen_entry_value Premium_Paid
7227: , value2.screen_entry_value Sum_Assured
7228: , value3.screen_entry_value Policy_Number
7229: , value4.screen_entry_value Policy_Start_Date
7230: FROM per_assignments_f assgn
7231: , pay_element_links_f link
7232: , pay_element_types_f types
7233: , pay_element_entries_f entries
7234: , pay_element_entry_values_f value1

Line 7299: FROM per_assignments_f assgn

7295: IS
7296: SELECT entries.element_entry_id entry_id
7297: , value1.screen_entry_value Investment_Amount
7298: , value2.screen_entry_value Component_Name
7299: FROM per_assignments_f assgn
7300: , pay_element_links_f link
7301: , pay_element_types_f types
7302: , pay_element_entries_f entries
7303: , pay_element_entry_values_f value1