DBA Data[Home] [Help]

APPS.PAY_KR_YEA_FORM_PKG dependencies on PER_ASSIGNMENT_EXTRA_INFO

Line 7: p_assignment_id in per_assignment_extra_info.assignment_id%type,

3: -------------------------------------------------------------------------------------------------------
4: procedure chk_detail_medical_record
5: (
6: p_effective_date in date,
7: p_assignment_id in per_assignment_extra_info.assignment_id%type,
8: p_provider_reg_no in per_assignment_extra_info.aei_information1%type,
9: p_provider_reg_name in per_assignment_extra_info.aei_information1%type,
10: p_res_reg_no in per_assignment_extra_info.aei_information1%type,
11: p_relationship in per_assignment_extra_info.aei_information1%type,

Line 8: p_provider_reg_no in per_assignment_extra_info.aei_information1%type,

4: procedure chk_detail_medical_record
5: (
6: p_effective_date in date,
7: p_assignment_id in per_assignment_extra_info.assignment_id%type,
8: p_provider_reg_no in per_assignment_extra_info.aei_information1%type,
9: p_provider_reg_name in per_assignment_extra_info.aei_information1%type,
10: p_res_reg_no in per_assignment_extra_info.aei_information1%type,
11: p_relationship in per_assignment_extra_info.aei_information1%type,
12: p_disabled_aged in per_assignment_extra_info.aei_information1%type,

Line 9: p_provider_reg_name in per_assignment_extra_info.aei_information1%type,

5: (
6: p_effective_date in date,
7: p_assignment_id in per_assignment_extra_info.assignment_id%type,
8: p_provider_reg_no in per_assignment_extra_info.aei_information1%type,
9: p_provider_reg_name in per_assignment_extra_info.aei_information1%type,
10: p_res_reg_no in per_assignment_extra_info.aei_information1%type,
11: p_relationship in per_assignment_extra_info.aei_information1%type,
12: p_disabled_aged in per_assignment_extra_info.aei_information1%type,
13: p_total_employee in out nocopy per_assignment_extra_info.aei_information1%type,

Line 10: p_res_reg_no in per_assignment_extra_info.aei_information1%type,

6: p_effective_date in date,
7: p_assignment_id in per_assignment_extra_info.assignment_id%type,
8: p_provider_reg_no in per_assignment_extra_info.aei_information1%type,
9: p_provider_reg_name in per_assignment_extra_info.aei_information1%type,
10: p_res_reg_no in per_assignment_extra_info.aei_information1%type,
11: p_relationship in per_assignment_extra_info.aei_information1%type,
12: p_disabled_aged in per_assignment_extra_info.aei_information1%type,
13: p_total_employee in out nocopy per_assignment_extra_info.aei_information1%type,
14: p_total_dependent in out nocopy per_assignment_extra_info.aei_information1%type,

Line 11: p_relationship in per_assignment_extra_info.aei_information1%type,

7: p_assignment_id in per_assignment_extra_info.assignment_id%type,
8: p_provider_reg_no in per_assignment_extra_info.aei_information1%type,
9: p_provider_reg_name in per_assignment_extra_info.aei_information1%type,
10: p_res_reg_no in per_assignment_extra_info.aei_information1%type,
11: p_relationship in per_assignment_extra_info.aei_information1%type,
12: p_disabled_aged in per_assignment_extra_info.aei_information1%type,
13: p_total_employee in out nocopy per_assignment_extra_info.aei_information1%type,
14: p_total_dependent in out nocopy per_assignment_extra_info.aei_information1%type,
15: p_total_aged in out nocopy per_assignment_extra_info.aei_information1%type,

Line 12: p_disabled_aged in per_assignment_extra_info.aei_information1%type,

8: p_provider_reg_no in per_assignment_extra_info.aei_information1%type,
9: p_provider_reg_name in per_assignment_extra_info.aei_information1%type,
10: p_res_reg_no in per_assignment_extra_info.aei_information1%type,
11: p_relationship in per_assignment_extra_info.aei_information1%type,
12: p_disabled_aged in per_assignment_extra_info.aei_information1%type,
13: p_total_employee in out nocopy per_assignment_extra_info.aei_information1%type,
14: p_total_dependent in out nocopy per_assignment_extra_info.aei_information1%type,
15: p_total_aged in out nocopy per_assignment_extra_info.aei_information1%type,
16: p_total_disabled in out nocopy per_assignment_extra_info.aei_information1%type,

Line 13: p_total_employee in out nocopy per_assignment_extra_info.aei_information1%type,

9: p_provider_reg_name in per_assignment_extra_info.aei_information1%type,
10: p_res_reg_no in per_assignment_extra_info.aei_information1%type,
11: p_relationship in per_assignment_extra_info.aei_information1%type,
12: p_disabled_aged in per_assignment_extra_info.aei_information1%type,
13: p_total_employee in out nocopy per_assignment_extra_info.aei_information1%type,
14: p_total_dependent in out nocopy per_assignment_extra_info.aei_information1%type,
15: p_total_aged in out nocopy per_assignment_extra_info.aei_information1%type,
16: p_total_disabled in out nocopy per_assignment_extra_info.aei_information1%type,
17: p_total_card_exp in out nocopy per_assignment_extra_info.aei_information1%type,

Line 14: p_total_dependent in out nocopy per_assignment_extra_info.aei_information1%type,

10: p_res_reg_no in per_assignment_extra_info.aei_information1%type,
11: p_relationship in per_assignment_extra_info.aei_information1%type,
12: p_disabled_aged in per_assignment_extra_info.aei_information1%type,
13: p_total_employee in out nocopy per_assignment_extra_info.aei_information1%type,
14: p_total_dependent in out nocopy per_assignment_extra_info.aei_information1%type,
15: p_total_aged in out nocopy per_assignment_extra_info.aei_information1%type,
16: p_total_disabled in out nocopy per_assignment_extra_info.aei_information1%type,
17: p_total_card_exp in out nocopy per_assignment_extra_info.aei_information1%type,
18: p_inv_provider_name out nocopy varchar2,

Line 15: p_total_aged in out nocopy per_assignment_extra_info.aei_information1%type,

11: p_relationship in per_assignment_extra_info.aei_information1%type,
12: p_disabled_aged in per_assignment_extra_info.aei_information1%type,
13: p_total_employee in out nocopy per_assignment_extra_info.aei_information1%type,
14: p_total_dependent in out nocopy per_assignment_extra_info.aei_information1%type,
15: p_total_aged in out nocopy per_assignment_extra_info.aei_information1%type,
16: p_total_disabled in out nocopy per_assignment_extra_info.aei_information1%type,
17: p_total_card_exp in out nocopy per_assignment_extra_info.aei_information1%type,
18: p_inv_provider_name out nocopy varchar2,
19: p_inv_relationship out nocopy varchar2,

Line 16: p_total_disabled in out nocopy per_assignment_extra_info.aei_information1%type,

12: p_disabled_aged in per_assignment_extra_info.aei_information1%type,
13: p_total_employee in out nocopy per_assignment_extra_info.aei_information1%type,
14: p_total_dependent in out nocopy per_assignment_extra_info.aei_information1%type,
15: p_total_aged in out nocopy per_assignment_extra_info.aei_information1%type,
16: p_total_disabled in out nocopy per_assignment_extra_info.aei_information1%type,
17: p_total_card_exp in out nocopy per_assignment_extra_info.aei_information1%type,
18: p_inv_provider_name out nocopy varchar2,
19: p_inv_relationship out nocopy varchar2,
20: p_inv_aged_disabled out nocopy varchar2

Line 17: p_total_card_exp in out nocopy per_assignment_extra_info.aei_information1%type,

13: p_total_employee in out nocopy per_assignment_extra_info.aei_information1%type,
14: p_total_dependent in out nocopy per_assignment_extra_info.aei_information1%type,
15: p_total_aged in out nocopy per_assignment_extra_info.aei_information1%type,
16: p_total_disabled in out nocopy per_assignment_extra_info.aei_information1%type,
17: p_total_card_exp in out nocopy per_assignment_extra_info.aei_information1%type,
18: p_inv_provider_name out nocopy varchar2,
19: p_inv_relationship out nocopy varchar2,
20: p_inv_aged_disabled out nocopy varchar2
21: );

Line 25: p_assignment_id in per_assignment_extra_info.assignment_id%type,

21: );
22: -------------------------------------------------------------------------------------------------------
23: function chk_dup_recipient_name (
24: p_effective_date in date,
25: p_assignment_id in per_assignment_extra_info.assignment_id%type,
26: p_recipient_reg_no in per_assignment_extra_info.aei_information1%type,
27: p_recipient_name in per_assignment_extra_info.aei_information1%type,
28: p_stat_total in out nocopy per_assignment_extra_info.aei_information1%type,
29: p_pol_total in out nocopy per_assignment_extra_info.aei_information1%type,

Line 26: p_recipient_reg_no in per_assignment_extra_info.aei_information1%type,

22: -------------------------------------------------------------------------------------------------------
23: function chk_dup_recipient_name (
24: p_effective_date in date,
25: p_assignment_id in per_assignment_extra_info.assignment_id%type,
26: p_recipient_reg_no in per_assignment_extra_info.aei_information1%type,
27: p_recipient_name in per_assignment_extra_info.aei_information1%type,
28: p_stat_total in out nocopy per_assignment_extra_info.aei_information1%type,
29: p_pol_total in out nocopy per_assignment_extra_info.aei_information1%type,
30: p_prom_fund_total in out nocopy per_assignment_extra_info.aei_information1%type,

Line 27: p_recipient_name in per_assignment_extra_info.aei_information1%type,

23: function chk_dup_recipient_name (
24: p_effective_date in date,
25: p_assignment_id in per_assignment_extra_info.assignment_id%type,
26: p_recipient_reg_no in per_assignment_extra_info.aei_information1%type,
27: p_recipient_name in per_assignment_extra_info.aei_information1%type,
28: p_stat_total in out nocopy per_assignment_extra_info.aei_information1%type,
29: p_pol_total in out nocopy per_assignment_extra_info.aei_information1%type,
30: p_prom_fund_total in out nocopy per_assignment_extra_info.aei_information1%type,
31: p_tax_redn_total in out nocopy per_assignment_extra_info.aei_information1%type,

Line 28: p_stat_total in out nocopy per_assignment_extra_info.aei_information1%type,

24: p_effective_date in date,
25: p_assignment_id in per_assignment_extra_info.assignment_id%type,
26: p_recipient_reg_no in per_assignment_extra_info.aei_information1%type,
27: p_recipient_name in per_assignment_extra_info.aei_information1%type,
28: p_stat_total in out nocopy per_assignment_extra_info.aei_information1%type,
29: p_pol_total in out nocopy per_assignment_extra_info.aei_information1%type,
30: p_prom_fund_total in out nocopy per_assignment_extra_info.aei_information1%type,
31: p_tax_redn_total in out nocopy per_assignment_extra_info.aei_information1%type,
32: p_specified_total in out nocopy per_assignment_extra_info.aei_information1%type,

Line 29: p_pol_total in out nocopy per_assignment_extra_info.aei_information1%type,

25: p_assignment_id in per_assignment_extra_info.assignment_id%type,
26: p_recipient_reg_no in per_assignment_extra_info.aei_information1%type,
27: p_recipient_name in per_assignment_extra_info.aei_information1%type,
28: p_stat_total in out nocopy per_assignment_extra_info.aei_information1%type,
29: p_pol_total in out nocopy per_assignment_extra_info.aei_information1%type,
30: p_prom_fund_total in out nocopy per_assignment_extra_info.aei_information1%type,
31: p_tax_redn_total in out nocopy per_assignment_extra_info.aei_information1%type,
32: p_specified_total in out nocopy per_assignment_extra_info.aei_information1%type,
33: p_religious_total in out nocopy per_assignment_extra_info.aei_information1%type,

Line 30: p_prom_fund_total in out nocopy per_assignment_extra_info.aei_information1%type,

26: p_recipient_reg_no in per_assignment_extra_info.aei_information1%type,
27: p_recipient_name in per_assignment_extra_info.aei_information1%type,
28: p_stat_total in out nocopy per_assignment_extra_info.aei_information1%type,
29: p_pol_total in out nocopy per_assignment_extra_info.aei_information1%type,
30: p_prom_fund_total in out nocopy per_assignment_extra_info.aei_information1%type,
31: p_tax_redn_total in out nocopy per_assignment_extra_info.aei_information1%type,
32: p_specified_total in out nocopy per_assignment_extra_info.aei_information1%type,
33: p_religious_total in out nocopy per_assignment_extra_info.aei_information1%type,
34: p_esoa_total in out nocopy per_assignment_extra_info.aei_information1%type,

Line 31: p_tax_redn_total in out nocopy per_assignment_extra_info.aei_information1%type,

27: p_recipient_name in per_assignment_extra_info.aei_information1%type,
28: p_stat_total in out nocopy per_assignment_extra_info.aei_information1%type,
29: p_pol_total in out nocopy per_assignment_extra_info.aei_information1%type,
30: p_prom_fund_total in out nocopy per_assignment_extra_info.aei_information1%type,
31: p_tax_redn_total in out nocopy per_assignment_extra_info.aei_information1%type,
32: p_specified_total in out nocopy per_assignment_extra_info.aei_information1%type,
33: p_religious_total in out nocopy per_assignment_extra_info.aei_information1%type,
34: p_esoa_total in out nocopy per_assignment_extra_info.aei_information1%type,
35: p_others_total in out nocopy per_assignment_extra_info.aei_information1%type,

Line 32: p_specified_total in out nocopy per_assignment_extra_info.aei_information1%type,

28: p_stat_total in out nocopy per_assignment_extra_info.aei_information1%type,
29: p_pol_total in out nocopy per_assignment_extra_info.aei_information1%type,
30: p_prom_fund_total in out nocopy per_assignment_extra_info.aei_information1%type,
31: p_tax_redn_total in out nocopy per_assignment_extra_info.aei_information1%type,
32: p_specified_total in out nocopy per_assignment_extra_info.aei_information1%type,
33: p_religious_total in out nocopy per_assignment_extra_info.aei_information1%type,
34: p_esoa_total in out nocopy per_assignment_extra_info.aei_information1%type,
35: p_others_total in out nocopy per_assignment_extra_info.aei_information1%type,
36: p_public_legal_total in out nocopy per_assignment_extra_info.aei_information1%type

Line 33: p_religious_total in out nocopy per_assignment_extra_info.aei_information1%type,

29: p_pol_total in out nocopy per_assignment_extra_info.aei_information1%type,
30: p_prom_fund_total in out nocopy per_assignment_extra_info.aei_information1%type,
31: p_tax_redn_total in out nocopy per_assignment_extra_info.aei_information1%type,
32: p_specified_total in out nocopy per_assignment_extra_info.aei_information1%type,
33: p_religious_total in out nocopy per_assignment_extra_info.aei_information1%type,
34: p_esoa_total in out nocopy per_assignment_extra_info.aei_information1%type,
35: p_others_total in out nocopy per_assignment_extra_info.aei_information1%type,
36: p_public_legal_total in out nocopy per_assignment_extra_info.aei_information1%type
37: ) return varchar2 ; -- Bug 7142612

Line 34: p_esoa_total in out nocopy per_assignment_extra_info.aei_information1%type,

30: p_prom_fund_total in out nocopy per_assignment_extra_info.aei_information1%type,
31: p_tax_redn_total in out nocopy per_assignment_extra_info.aei_information1%type,
32: p_specified_total in out nocopy per_assignment_extra_info.aei_information1%type,
33: p_religious_total in out nocopy per_assignment_extra_info.aei_information1%type,
34: p_esoa_total in out nocopy per_assignment_extra_info.aei_information1%type,
35: p_others_total in out nocopy per_assignment_extra_info.aei_information1%type,
36: p_public_legal_total in out nocopy per_assignment_extra_info.aei_information1%type
37: ) return varchar2 ; -- Bug 7142612
38: -------------------------------------------------------------------------------------------------------

Line 35: p_others_total in out nocopy per_assignment_extra_info.aei_information1%type,

31: p_tax_redn_total in out nocopy per_assignment_extra_info.aei_information1%type,
32: p_specified_total in out nocopy per_assignment_extra_info.aei_information1%type,
33: p_religious_total in out nocopy per_assignment_extra_info.aei_information1%type,
34: p_esoa_total in out nocopy per_assignment_extra_info.aei_information1%type,
35: p_others_total in out nocopy per_assignment_extra_info.aei_information1%type,
36: p_public_legal_total in out nocopy per_assignment_extra_info.aei_information1%type
37: ) return varchar2 ; -- Bug 7142612
38: -------------------------------------------------------------------------------------------------------
39: function get_donation_tax_break(p_effective_date IN VARCHAR2,

Line 36: p_public_legal_total in out nocopy per_assignment_extra_info.aei_information1%type

32: p_specified_total in out nocopy per_assignment_extra_info.aei_information1%type,
33: p_religious_total in out nocopy per_assignment_extra_info.aei_information1%type,
34: p_esoa_total in out nocopy per_assignment_extra_info.aei_information1%type,
35: p_others_total in out nocopy per_assignment_extra_info.aei_information1%type,
36: p_public_legal_total in out nocopy per_assignment_extra_info.aei_information1%type
37: ) return varchar2 ; -- Bug 7142612
38: -------------------------------------------------------------------------------------------------------
39: function get_donation_tax_break(p_effective_date IN VARCHAR2,
40: p_political_donation IN NUMBER) return number;