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_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: from per_assignment_extra_info

21: )
22: is
23: cursor csr_dup_provider_name is
24: select 'Y'
25: from per_assignment_extra_info
26: where
27: assignment_id = p_assignment_id and
28: information_type = 'KR_YEA_DETAIL_MEDICAL_EXP_INFO' and
29: aei_information5 = p_provider_reg_no and

Line 38: from per_assignment_extra_info

34: cursor csr_dup_relation_aged_disabled is
35: select
36: decode(aei_information7,p_relationship,'N','Y') inv_relationship,
37: decode(aei_information9,p_disabled_aged,'N','Y') inv_aged_disabled
38: from per_assignment_extra_info
39: where
40: assignment_id = p_assignment_id and
41: information_type = 'KR_YEA_DETAIL_MEDICAL_EXP_INFO' and
42: aei_information8 = p_res_reg_no and

Line 51: from per_assignment_extra_info pai

47: select aei_information24, -- employee
48: aei_information7, -- dependent
49: aei_information9, -- aged
50: aei_information8 -- disabled
51: from per_assignment_extra_info pai
52: where
53: pai.assignment_id = p_assignment_id and
54: pai.information_type = 'KR_YEA_SP_TAX_EXEM_INFO' and
55: trunc(fnd_date.canonical_to_date(aei_information1), 'YYYY') =

Line 60: from per_assignment_extra_info pai

56: trunc(p_effective_date, 'YYYY');
57: -- Bug 4704848
58: Cursor csr_total_card_exp is
59: select aei_information3 -- card expense
60: from per_assignment_extra_info pai
61: where
62: pai.assignment_id = p_assignment_id and
63: pai.information_type = 'KR_YEA_SP_TAX_EXEM_INFO2' and
64: trunc(fnd_date.canonical_to_date(aei_information1), 'YYYY') =

Line 122: p_assignment_id in per_assignment_extra_info.assignment_id%type,

118: End;
119: -------------------------------------------------------------------------------------------------------
120: function chk_dup_recipient_name (
121: p_effective_date in date,
122: p_assignment_id in per_assignment_extra_info.assignment_id%type,
123: p_recipient_reg_no in per_assignment_extra_info.aei_information1%type,
124: p_recipient_name in per_assignment_extra_info.aei_information1%type,
125: p_stat_total in out nocopy per_assignment_extra_info.aei_information1%type,
126: p_pol_total in out nocopy per_assignment_extra_info.aei_information1%type,

Line 123: p_recipient_reg_no in per_assignment_extra_info.aei_information1%type,

119: -------------------------------------------------------------------------------------------------------
120: function chk_dup_recipient_name (
121: p_effective_date in date,
122: p_assignment_id in per_assignment_extra_info.assignment_id%type,
123: p_recipient_reg_no in per_assignment_extra_info.aei_information1%type,
124: p_recipient_name in per_assignment_extra_info.aei_information1%type,
125: p_stat_total in out nocopy per_assignment_extra_info.aei_information1%type,
126: p_pol_total in out nocopy per_assignment_extra_info.aei_information1%type,
127: p_prom_fund_total in out nocopy per_assignment_extra_info.aei_information1%type,

Line 124: p_recipient_name in per_assignment_extra_info.aei_information1%type,

120: function chk_dup_recipient_name (
121: p_effective_date in date,
122: p_assignment_id in per_assignment_extra_info.assignment_id%type,
123: p_recipient_reg_no in per_assignment_extra_info.aei_information1%type,
124: p_recipient_name in per_assignment_extra_info.aei_information1%type,
125: p_stat_total in out nocopy per_assignment_extra_info.aei_information1%type,
126: p_pol_total in out nocopy per_assignment_extra_info.aei_information1%type,
127: p_prom_fund_total in out nocopy per_assignment_extra_info.aei_information1%type,
128: p_tax_redn_total in out nocopy per_assignment_extra_info.aei_information1%type,

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

121: p_effective_date in date,
122: p_assignment_id in per_assignment_extra_info.assignment_id%type,
123: p_recipient_reg_no in per_assignment_extra_info.aei_information1%type,
124: p_recipient_name in per_assignment_extra_info.aei_information1%type,
125: p_stat_total in out nocopy per_assignment_extra_info.aei_information1%type,
126: p_pol_total in out nocopy per_assignment_extra_info.aei_information1%type,
127: p_prom_fund_total in out nocopy per_assignment_extra_info.aei_information1%type,
128: p_tax_redn_total in out nocopy per_assignment_extra_info.aei_information1%type,
129: p_specified_total in out nocopy per_assignment_extra_info.aei_information1%type,

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

122: p_assignment_id in per_assignment_extra_info.assignment_id%type,
123: p_recipient_reg_no in per_assignment_extra_info.aei_information1%type,
124: p_recipient_name in per_assignment_extra_info.aei_information1%type,
125: p_stat_total in out nocopy per_assignment_extra_info.aei_information1%type,
126: p_pol_total in out nocopy per_assignment_extra_info.aei_information1%type,
127: p_prom_fund_total in out nocopy per_assignment_extra_info.aei_information1%type,
128: p_tax_redn_total in out nocopy per_assignment_extra_info.aei_information1%type,
129: p_specified_total in out nocopy per_assignment_extra_info.aei_information1%type,
130: p_religious_total in out nocopy per_assignment_extra_info.aei_information1%type,

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

123: p_recipient_reg_no in per_assignment_extra_info.aei_information1%type,
124: p_recipient_name in per_assignment_extra_info.aei_information1%type,
125: p_stat_total in out nocopy per_assignment_extra_info.aei_information1%type,
126: p_pol_total in out nocopy per_assignment_extra_info.aei_information1%type,
127: p_prom_fund_total in out nocopy per_assignment_extra_info.aei_information1%type,
128: p_tax_redn_total in out nocopy per_assignment_extra_info.aei_information1%type,
129: p_specified_total in out nocopy per_assignment_extra_info.aei_information1%type,
130: p_religious_total in out nocopy per_assignment_extra_info.aei_information1%type,
131: p_esoa_total in out nocopy per_assignment_extra_info.aei_information1%type,

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

124: p_recipient_name in per_assignment_extra_info.aei_information1%type,
125: p_stat_total in out nocopy per_assignment_extra_info.aei_information1%type,
126: p_pol_total in out nocopy per_assignment_extra_info.aei_information1%type,
127: p_prom_fund_total in out nocopy per_assignment_extra_info.aei_information1%type,
128: p_tax_redn_total in out nocopy per_assignment_extra_info.aei_information1%type,
129: p_specified_total in out nocopy per_assignment_extra_info.aei_information1%type,
130: p_religious_total in out nocopy per_assignment_extra_info.aei_information1%type,
131: p_esoa_total in out nocopy per_assignment_extra_info.aei_information1%type,
132: p_others_total in out nocopy per_assignment_extra_info.aei_information1%type,

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

125: p_stat_total in out nocopy per_assignment_extra_info.aei_information1%type,
126: p_pol_total in out nocopy per_assignment_extra_info.aei_information1%type,
127: p_prom_fund_total in out nocopy per_assignment_extra_info.aei_information1%type,
128: p_tax_redn_total in out nocopy per_assignment_extra_info.aei_information1%type,
129: p_specified_total in out nocopy per_assignment_extra_info.aei_information1%type,
130: p_religious_total in out nocopy per_assignment_extra_info.aei_information1%type,
131: p_esoa_total in out nocopy per_assignment_extra_info.aei_information1%type,
132: p_others_total in out nocopy per_assignment_extra_info.aei_information1%type,
133: p_public_legal_total in out nocopy per_assignment_extra_info.aei_information1%type

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

126: p_pol_total in out nocopy per_assignment_extra_info.aei_information1%type,
127: p_prom_fund_total in out nocopy per_assignment_extra_info.aei_information1%type,
128: p_tax_redn_total in out nocopy per_assignment_extra_info.aei_information1%type,
129: p_specified_total in out nocopy per_assignment_extra_info.aei_information1%type,
130: p_religious_total in out nocopy per_assignment_extra_info.aei_information1%type,
131: p_esoa_total in out nocopy per_assignment_extra_info.aei_information1%type,
132: p_others_total in out nocopy per_assignment_extra_info.aei_information1%type,
133: p_public_legal_total in out nocopy per_assignment_extra_info.aei_information1%type
134: ) return varchar2 -- Bug 7142612

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

127: p_prom_fund_total in out nocopy per_assignment_extra_info.aei_information1%type,
128: p_tax_redn_total in out nocopy per_assignment_extra_info.aei_information1%type,
129: p_specified_total in out nocopy per_assignment_extra_info.aei_information1%type,
130: p_religious_total in out nocopy per_assignment_extra_info.aei_information1%type,
131: p_esoa_total in out nocopy per_assignment_extra_info.aei_information1%type,
132: p_others_total in out nocopy per_assignment_extra_info.aei_information1%type,
133: p_public_legal_total in out nocopy per_assignment_extra_info.aei_information1%type
134: ) return varchar2 -- Bug 7142612
135: is

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

128: p_tax_redn_total in out nocopy per_assignment_extra_info.aei_information1%type,
129: p_specified_total in out nocopy per_assignment_extra_info.aei_information1%type,
130: p_religious_total in out nocopy per_assignment_extra_info.aei_information1%type,
131: p_esoa_total in out nocopy per_assignment_extra_info.aei_information1%type,
132: p_others_total in out nocopy per_assignment_extra_info.aei_information1%type,
133: p_public_legal_total in out nocopy per_assignment_extra_info.aei_information1%type
134: ) return varchar2 -- Bug 7142612
135: is
136: cursor csr_dup_recipient_name is

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

129: p_specified_total in out nocopy per_assignment_extra_info.aei_information1%type,
130: p_religious_total in out nocopy per_assignment_extra_info.aei_information1%type,
131: p_esoa_total in out nocopy per_assignment_extra_info.aei_information1%type,
132: p_others_total in out nocopy per_assignment_extra_info.aei_information1%type,
133: p_public_legal_total in out nocopy per_assignment_extra_info.aei_information1%type
134: ) return varchar2 -- Bug 7142612
135: is
136: cursor csr_dup_recipient_name is
137: select 'Y'

Line 138: from per_assignment_extra_info

134: ) return varchar2 -- Bug 7142612
135: is
136: cursor csr_dup_recipient_name is
137: select 'Y'
138: from per_assignment_extra_info
139: where
140: assignment_id = p_assignment_id
141: and information_type = 'KR_YEA_DETAIL_DONATION_INFO'
142: and aei_information7 = p_recipient_reg_no

Line 152: from per_assignment_extra_info pai

148: aei_information20, -- Political
149: aei_information22, -- Specified
150: aei_information23, -- Tax Reduction Law
151: aei_information30 -- ESOA
152: from per_assignment_extra_info pai
153: where
154: pai.assignment_id = p_assignment_id
155: and pai.information_type = 'KR_YEA_SP_TAX_EXEM_INFO'
156: and trunc(fnd_date.canonical_to_date(aei_information1), 'YYYY') =

Line 164: from per_assignment_extra_info pai

160: select aei_information4, -- Promotional Fund
161: aei_information5, -- Religious
162: aei_information6, -- Others
163: aei_information7 -- Public Legal Entity Donation Trust -- Bug 7142612
164: from per_assignment_extra_info pai
165: where
166: pai.assignment_id = p_assignment_id
167: and pai.information_type = 'KR_YEA_SP_TAX_EXEM_INFO2'
168: and trunc(fnd_date.canonical_to_date(aei_information1), 'YYYY') =