DBA Data[Home] [Help]

APPS.PAY_NL_ANNUAL_SI_FILE dependencies on PAY_NL_GENERAL

Line 78: l_defined_balance_id:=pay_nl_general.get_defined_balance_id('SI_INCOME_STANDARD_TAX_ASG_YTD');

74:
75: l_sum_of_balances:=0;
76:
77:
78: l_defined_balance_id:=pay_nl_general.get_defined_balance_id('SI_INCOME_STANDARD_TAX_ASG_YTD');
79: --hr_utility.trace('L_DEFINED_BALANCE_ID'||l_defined_balance_id);
80: --hr_utility.trace('ASSIGNMENT_ACTION_ID'||p_assgt_act_id);
81: l_balance_value:=pay_balance_pkg.get_value(l_defined_balance_id,p_assgt_act_id);
82: l_sum_of_balances:=l_sum_of_balances + l_balance_value;

Line 91: l_defined_balance_id:=pay_nl_general.get_defined_balance_id('SI_INCOME_SPECIAL_TAX_ASG_YTD');

87: hr_utility.set_location('l_balance_value'||l_balance_value,425);
88: hr_utility.set_location('l_sum_of_balances'||l_sum_of_balances,425);
89: end if;
90:
91: l_defined_balance_id:=pay_nl_general.get_defined_balance_id('SI_INCOME_SPECIAL_TAX_ASG_YTD');
92: l_balance_value:=pay_balance_pkg.get_value(l_defined_balance_id,p_assgt_act_id);
93: l_sum_of_balances:=l_sum_of_balances + l_balance_value;
94:
95: if g_debug then

Line 102: l_defined_balance_id:=pay_nl_general.get_defined_balance_id('RETRO_SI_INCOME_STANDARD_TAX_ASG_YTD');

98: hr_utility.set_location('l_balance_value'||l_balance_value,425);
99: hr_utility.set_location('l_sum_of_balances'||l_sum_of_balances,425);
100: end if;
101:
102: l_defined_balance_id:=pay_nl_general.get_defined_balance_id('RETRO_SI_INCOME_STANDARD_TAX_ASG_YTD');
103: l_balance_value:=pay_balance_pkg.get_value(l_defined_balance_id,p_assgt_act_id);
104: l_sum_of_balances:=l_sum_of_balances + l_balance_value;
105:
106: if g_debug then

Line 113: l_defined_balance_id:=pay_nl_general.get_defined_balance_id('RETRO_SI_INCOME_SPECIAL_TAX_ASG_YTD');

109: hr_utility.set_location('l_balance_value'||l_balance_value,425);
110: hr_utility.set_location('l_sum_of_balances'||l_sum_of_balances,425);
111: end if;
112:
113: l_defined_balance_id:=pay_nl_general.get_defined_balance_id('RETRO_SI_INCOME_SPECIAL_TAX_ASG_YTD');
114: l_balance_value:=pay_balance_pkg.get_value(l_defined_balance_id,p_assgt_act_id);
115: l_sum_of_balances:=l_sum_of_balances + l_balance_value;
116:
117: if g_debug then

Line 152: l_defined_balance_id:=pay_nl_general.get_defined_balance_id('SI_SUPPLEMENTARY_DAYS_ASG_YTD');

148:
149: l_sum_of_balances:=0;
150:
151:
152: l_defined_balance_id:=pay_nl_general.get_defined_balance_id('SI_SUPPLEMENTARY_DAYS_ASG_YTD');
153: l_balance_value:=pay_balance_pkg.get_value(l_defined_balance_id,p_assgt_act_id);
154: l_sum_of_balances:=l_sum_of_balances + l_balance_value;
155:
156: if g_debug then

Line 190: l_defined_balance_id:=pay_nl_general.get_defined_balance_id('SI_AMOUNT_ALLOWANCE_ASG_YTD');

186:
187: l_sum_of_balances:=0;
188:
189:
190: l_defined_balance_id:=pay_nl_general.get_defined_balance_id('SI_AMOUNT_ALLOWANCE_ASG_YTD');
191: l_balance_value:=pay_balance_pkg.get_value(l_defined_balance_id,p_assgt_act_id);
192: l_sum_of_balances:=l_sum_of_balances + l_balance_value;
193:
194: if g_debug then

Line 306: l_defined_balance_id:=pay_nl_general.get_defined_balance_id('REAL_SOCIAL_INSURANCE_DAYS_ASG_SIT_YTD');

302:
303: l_sum_of_balances:=0;
304:
305:
306: l_defined_balance_id:=pay_nl_general.get_defined_balance_id('REAL_SOCIAL_INSURANCE_DAYS_ASG_SIT_YTD');
307: OPEN csr_get_context_id('SOURCE_TEXT',p_assgt_act_id);
308: FETCH csr_get_context_id INTO l_context_id,l_context_value,l_seq;
309: CLOSE csr_get_context_id;
310:

Line 549: l_org_address:=PAY_NL_GENERAL.GET_ORGANIZATION_ADDRESS(l_employer_id,l_business_group_id,l_house_number,l_house_no_add,l_street_name,l_line1,l_line2,l_line3,l_city,l_country,l_postal_code);

545: l_Sender_Reg_Number_bg,
546: l_Wage_Tax_Rep_Name_org,
547: l_Wage_Tax_Reg_Number_org);
548:
549: l_org_address:=PAY_NL_GENERAL.GET_ORGANIZATION_ADDRESS(l_employer_id,l_business_group_id,l_house_number,l_house_no_add,l_street_name,l_line1,l_line2,l_line3,l_city,l_country,l_postal_code);
550: l_sender_address:=PAY_NL_GENERAL.GET_ORGANIZATION_ADDRESS(l_business_group_id,l_business_group_id,l_sen_house_number,l_sen_house_no_add,l_sen_street_name,l_sen_line1,l_sen_line2,l_sen_line3,l_sen_city,l_sen_country,l_sen_postal_code);
551:
552: l_sender_address_field := l_sen_street_name || l_sen_house_number || l_sen_house_no_add;
553: l_sen_city_field := l_sen_postal_code || l_sen_city;

Line 550: l_sender_address:=PAY_NL_GENERAL.GET_ORGANIZATION_ADDRESS(l_business_group_id,l_business_group_id,l_sen_house_number,l_sen_house_no_add,l_sen_street_name,l_sen_line1,l_sen_line2,l_sen_line3,l_sen_city,l_sen_country,l_sen_postal_code);

546: l_Wage_Tax_Rep_Name_org,
547: l_Wage_Tax_Reg_Number_org);
548:
549: l_org_address:=PAY_NL_GENERAL.GET_ORGANIZATION_ADDRESS(l_employer_id,l_business_group_id,l_house_number,l_house_no_add,l_street_name,l_line1,l_line2,l_line3,l_city,l_country,l_postal_code);
550: l_sender_address:=PAY_NL_GENERAL.GET_ORGANIZATION_ADDRESS(l_business_group_id,l_business_group_id,l_sen_house_number,l_sen_house_no_add,l_sen_street_name,l_sen_line1,l_sen_line2,l_sen_line3,l_sen_city,l_sen_country,l_sen_postal_code);
551:
552: l_sender_address_field := l_sen_street_name || l_sen_house_number || l_sen_house_no_add;
553: l_sen_city_field := l_sen_postal_code || l_sen_city;
554: l_tax_address_field := l_street_name || l_house_number || l_house_no_add;