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_NL_PAYSLIP_ARCHIVE dependencies on PAY_BALANCE_PKG

Line 1890: l_si_days := pay_balance_pkg.get_value(l_si_def_bal_id

1886: BEGIN
1887: l_si_days:=0;
1888:
1889: IF l_context_id IS NOT NULL THEN
1890: l_si_days := pay_balance_pkg.get_value(l_si_def_bal_id
1891: ,p_master_asg_act_id
1892: ,NULL
1893: ,NULL
1894: ,l_context_id

Line 2508: l_balance_value := pay_balance_pkg.get_value(p_defined_bal_id,p_source_id

2504:
2505: FOR context_rec IN csr_get_si_types(p_source_id,'SOURCE_TEXT')
2506: LOOP
2507: --
2508: l_balance_value := pay_balance_pkg.get_value(p_defined_bal_id,p_source_id
2509: ,null,null,context_rec.context_id,context_rec.value
2510: ,null,null);
2511: --
2512: IF l_balance_value <> 0 THEN

Line 2575: l_balance_value := pay_balance_pkg.get_value(p_defined_bal_id,p_source_id

2571: END;
2572:
2573: hr_utility.set_location('Inside process_balance l_context_id'||l_context_id,1840);
2574:
2575: l_balance_value := pay_balance_pkg.get_value(p_defined_bal_id,p_source_id
2576: ,null,null,l_context_id,p_si_type
2577: ,null,null);
2578: --
2579:

Line 2637: l_balance_value := pay_balance_pkg.get_value(p_defined_bal_id

2633: hr_utility.set_location('Inside process_balance p_balance'||p_balance,1850);
2634: hr_utility.set_location('Inside process_balance p_defined_bal_id'||p_defined_bal_id,1850);
2635: hr_utility.set_location('Inside process_balance p_source_id'||p_source_id,1850);
2636: BEGIN
2637: l_balance_value := pay_balance_pkg.get_value(p_defined_bal_id
2638: ,p_source_id);
2639: EXCEPTION
2640: WHEN OTHERS THEN
2641: hr_utility.set_location('Inside process_balance'||SQLCODE||SQLERRM,1849);

Line 3167: l_rate := pay_balance_pkg.get_value(l_defined_balance_id

3163: hr_utility.set_location('Inside archive_payslip_element_info1 l_defined_balance_id'||l_defined_balance_id,2121);
3164: hr_utility.set_location('Inside archive_payslip_element_info1 p_run_assign_action_id'||p_run_assign_action_id,2121);
3165:
3166: IF l_defined_balance_id IS NOT NULL THEN
3167: l_rate := pay_balance_pkg.get_value(l_defined_balance_id
3168: ,p_run_assign_action_id);
3169: ELSE
3170: l_rate :=NULL;
3171: END IF;

Line 3402: l_rate := pay_balance_pkg.get_value(l_defined_balance_id

3398: --5957039
3399:
3400: --FND_FILE.PUT_LINE(FND_FILE.LOG, 'l_defined_balance_id'||' '||l_defined_balance_id);
3401: IF l_defined_balance_id IS NOT NULL THEN
3402: l_rate := pay_balance_pkg.get_value(l_defined_balance_id
3403: ,csr_np_rec.np_assignment_action_id);
3404: ELSE
3405: l_rate :=NULL;
3406: END IF;

Line 3613: l_rate := pay_balance_pkg.get_value(l_defined_balance_id

3609: --hr_utility.set_location('Inside archive_payslip_element_info2 l_defined_balance_id'||l_defined_balance_id,2121);
3610: --hr_utility.set_location('Inside archive_payslip_element_info2 np_assignment_action_id'||csr_np_rec.np_assignment_action_id,2121);
3611:
3612: IF l_defined_balance_id IS NOT NULL THEN
3613: l_rate := pay_balance_pkg.get_value(l_defined_balance_id
3614: ,csr_np_rec.np_assignment_action_id);
3615: ELSE
3616: l_rate :=NULL;
3617: END IF;

Line 4015: l_standard_rate_run := pay_balance_pkg.get_value(

4011: IF p_standard_bal_name IS NOT NULL THEN
4012: --
4013:
4014: l_def_bal_id := get_defined_balance_id (p_standard_bal_name,'_ASG_SIT_RUN');
4015: l_standard_rate_run := pay_balance_pkg.get_value(
4016: l_def_bal_id, csr_np_rec.np_assignment_action_id
4017: ,null,null,context_rec.context_id,context_rec.value
4018: ,null,null);
4019:

Line 4025: l_standard_rate_ytd := pay_balance_pkg.get_value(

4021:
4022: -- YTD Figure
4023: --
4024: l_def_bal_id := get_defined_balance_id (p_standard_bal_name,'_ASG_SIT_YTD');
4025: l_standard_rate_ytd := pay_balance_pkg.get_value(
4026: l_def_bal_id, csr_np_rec.np_assignment_action_id
4027: ,null,null,context_rec.context_id,context_rec.value
4028: ,null,null);
4029: l_standard_rate_ytd := NVL(l_standard_rate_ytd,0) * p_multiply_factor;

Line 4039: l_special_rate_run := pay_balance_pkg.get_value(

4035: -- If Special Balance exist for this balance then retrive them
4036: IF p_special_bal_name IS NOT NULL THEN
4037: --
4038: l_def_bal_id := get_defined_balance_id(p_special_bal_name,'_ASG_SIT_RUN');
4039: l_special_rate_run := pay_balance_pkg.get_value(
4040: l_def_bal_id, csr_np_rec.np_assignment_action_id
4041: ,null,null,context_rec.context_id,context_rec.value
4042: ,null,null);
4043: l_special_rate_run := NVL(l_special_rate_run,0) * p_multiply_factor;

Line 4047: l_special_rate_ytd := pay_balance_pkg.get_value(

4043: l_special_rate_run := NVL(l_special_rate_run,0) * p_multiply_factor;
4044: -- YTD Figure
4045: --
4046: l_def_bal_id := get_defined_balance_id(p_special_bal_name,'_ASG_SIT_YTD');
4047: l_special_rate_ytd := pay_balance_pkg.get_value(
4048: l_def_bal_id, csr_np_rec.np_assignment_action_id
4049: ,null,null,context_rec.context_id,context_rec.value
4050: ,null,null);
4051: l_special_rate_ytd := NVL(l_special_rate_ytd,0) * p_multiply_factor;

Line 4061: l_non_tax_rate_run := pay_balance_pkg.get_value(

4057: -- If Non Taxable Balance exist for this balance then retrive them
4058: IF p_non_tax_bal_name IS NOT NULL THEN
4059: --
4060: l_def_bal_id := get_defined_balance_id(p_non_tax_bal_name,'_ASG_SIT_RUN');
4061: l_non_tax_rate_run := pay_balance_pkg.get_value(
4062: l_def_bal_id, csr_np_rec.np_assignment_action_id
4063: ,null,null,context_rec.context_id,context_rec.value
4064: ,null,null);
4065: l_non_tax_rate_run := NVL(l_non_tax_rate_run,0) * p_multiply_factor;

Line 4070: l_non_tax_rate_ytd := pay_balance_pkg.get_value(

4066:
4067: -- YTD Figure
4068: --
4069: l_def_bal_id := get_defined_balance_id(p_non_tax_bal_name,'_ASG_SIT_YTD');
4070: l_non_tax_rate_ytd := pay_balance_pkg.get_value(
4071: l_def_bal_id, csr_np_rec.np_assignment_action_id
4072: ,null,null,context_rec.context_id,context_rec.value
4073: ,null,null);
4074: l_non_tax_rate_ytd := NVL(l_non_tax_rate_ytd,0) * p_multiply_factor;

Line 4089: l_payable := pay_balance_pkg.get_value(

4085: --
4086: l_def_bal_id := get_defined_balance_id (p_balance_name
4087: ,'_ASG_SIT_RUN');
4088: IF p_payable_flag = 'Y' THEN
4089: l_payable := pay_balance_pkg.get_value(
4090: l_def_bal_id,csr_np_rec.np_assignment_action_id
4091: ,null,null,context_rec.context_id,context_rec.value
4092: ,null,null);
4093: l_payable := nvl(l_payable,0) * p_multiply_factor;

Line 4097: l_year := pay_balance_pkg.get_value(

4093: l_payable := nvl(l_payable,0) * p_multiply_factor;
4094: END IF;
4095: --
4096: l_def_bal_id := get_defined_balance_id (p_balance_name,'_ASG_SIT_YTD');
4097: l_year := pay_balance_pkg.get_value(
4098: l_def_bal_id, csr_np_rec.np_assignment_action_id
4099: ,null,null,context_rec.context_id,context_rec.value
4100: ,null,null);
4101: l_year := nvl(l_year,0) * p_multiply_factor;

Line 4263: l_standard_rate_run := pay_balance_pkg.get_value(

4259: -- If Standard balance exist for this balance then retrive them
4260: IF p_standard_bal_name IS NOT NULL THEN
4261: --
4262: l_def_bal_id := get_defined_balance_id (p_standard_bal_name,'_ASG_RUN');
4263: l_standard_rate_run := pay_balance_pkg.get_value(
4264: l_def_bal_id, csr_np_rec.np_assignment_action_id);
4265: l_standard_rate_run := NVL(l_standard_rate_run,0) * p_multiply_factor;
4266: -- YTD Value
4267: --

Line 4269: l_standard_rate_ytd := pay_balance_pkg.get_value(

4265: l_standard_rate_run := NVL(l_standard_rate_run,0) * p_multiply_factor;
4266: -- YTD Value
4267: --
4268: l_def_bal_id := get_defined_balance_id (p_standard_bal_name,'_ASG_YTD');
4269: l_standard_rate_ytd := pay_balance_pkg.get_value(
4270: l_def_bal_id, csr_np_rec.np_assignment_action_id);
4271: l_standard_rate_ytd := NVL(l_standard_rate_ytd,0) * p_multiply_factor;
4272: --
4273:

Line 4282: l_special_rate_run := pay_balance_pkg.get_value(

4278: -- If Special Balance exist for this balance then retrive them
4279: IF p_special_bal_name IS NOT NULL THEN
4280: --
4281: l_def_bal_id := get_defined_balance_id(p_special_bal_name,'_ASG_RUN');
4282: l_special_rate_run := pay_balance_pkg.get_value(
4283: l_def_bal_id, csr_np_rec.np_assignment_action_id);
4284: l_special_rate_run := NVL(l_special_rate_run,0) * p_multiply_factor;
4285: -- YTD Value
4286: --

Line 4288: l_special_rate_ytd := pay_balance_pkg.get_value(l_def_bal_id, csr_np_rec.np_assignment_action_id);

4284: l_special_rate_run := NVL(l_special_rate_run,0) * p_multiply_factor;
4285: -- YTD Value
4286: --
4287: l_def_bal_id := get_defined_balance_id(p_special_bal_name,'_ASG_YTD');
4288: l_special_rate_ytd := pay_balance_pkg.get_value(l_def_bal_id, csr_np_rec.np_assignment_action_id);
4289: l_special_rate_ytd := NVL(l_special_rate_ytd,0) * p_multiply_factor;
4290: --
4291: END IF;
4292:

Line 4299: l_non_tax_rate_run := pay_balance_pkg.get_value(l_def_bal_id, csr_np_rec.np_assignment_action_id);

4295: -- If Non Taxable Balance exist for this balance then retrive them
4296: IF p_non_tax_bal_name IS NOT NULL THEN
4297: --
4298: l_def_bal_id := get_defined_balance_id(p_non_tax_bal_name,'_ASG_RUN');
4299: l_non_tax_rate_run := pay_balance_pkg.get_value(l_def_bal_id, csr_np_rec.np_assignment_action_id);
4300: l_non_tax_rate_run := NVL(l_non_tax_rate_run,0) * p_multiply_factor;
4301: -- YTD Value
4302: --
4303: l_def_bal_id := get_defined_balance_id(p_non_tax_bal_name,'_ASG_YTD');

Line 4304: l_non_tax_rate_ytd := pay_balance_pkg.get_value(l_def_bal_id, csr_np_rec.np_assignment_action_id);

4300: l_non_tax_rate_run := NVL(l_non_tax_rate_run,0) * p_multiply_factor;
4301: -- YTD Value
4302: --
4303: l_def_bal_id := get_defined_balance_id(p_non_tax_bal_name,'_ASG_YTD');
4304: l_non_tax_rate_ytd := pay_balance_pkg.get_value(l_def_bal_id, csr_np_rec.np_assignment_action_id);
4305: l_non_tax_rate_ytd := NVL(l_non_tax_rate_ytd,0) * p_multiply_factor;
4306: --
4307:
4308: END IF;

Line 4323: l_payable := pay_balance_pkg.get_value(l_def_bal_id

4319: --
4320: l_def_bal_id := get_defined_balance_id (p_balance_name,'_ASG_RUN');
4321: --hr_utility.set_location('Inside archive_balance_info l_def_bal_id'||l_def_bal_id,2152);
4322: IF p_payable_flag = 'Y' THEN
4323: l_payable := pay_balance_pkg.get_value(l_def_bal_id
4324: , csr_np_rec.np_assignment_action_id);
4325: IF p_balance_name = 'Gross Salary' THEN
4326: l_payable := l_payable - (g_zvw_er_cont_std_run +
4327: g_zvw_er_cont_spl_run +

Line 4340: l_year := pay_balance_pkg.get_value(l_def_bal_id, csr_np_rec.np_assignment_action_id);

4336: --
4337: l_def_bal_id := get_defined_balance_id (p_balance_name,'_ASG_YTD');
4338: --hr_utility.set_location('Inside archive_balance_info l_def_bal_id'||l_def_bal_id,2153);
4339:
4340: l_year := pay_balance_pkg.get_value(l_def_bal_id, csr_np_rec.np_assignment_action_id);
4341: IF p_balance_name = 'Gross Salary' THEN
4342: l_year := l_year - (g_zvw_er_cont_std_ytd +
4343: g_zvw_er_cont_spl_ytd +
4344: g_retro_zvw_er_cont_std_ytd +

Line 4849: l_standard_year := pay_balance_pkg.get_value(l_def_bal_id

4845: CLOSE csr_retro_values;
4846: l_def_bal_id := get_defined_balance_id (p_standard_bal_name,'_ASG_SIT_YTD');
4847: --FND_FILE.PUT_LINE(FND_FILE.LOG, 'l_def_bal_id'||' '||l_def_bal_id);
4848: IF l_def_bal_id IS NOT NULL THEN
4849: l_standard_year := pay_balance_pkg.get_value(l_def_bal_id
4850: ,csr_np_rec.np_assignment_action_id,null,null,context_rec.context_id,context_rec.value,null,null);
4851: END IF;
4852: --FND_FILE.PUT_LINE(FND_FILE.LOG, 'l_standard_year'||' '||l_standard_year);
4853:

Line 4889: l_special_year := pay_balance_pkg.get_value(l_def_bal_id

4885: l_def_bal_id := get_defined_balance_id (p_special_bal_name,'_ASG_SIT_YTD');
4886: --FND_FILE.PUT_LINE(FND_FILE.LOG, 'l_def_bal_id'||' '||l_def_bal_id);
4887:
4888: IF l_def_bal_id IS NOT NULL THEN
4889: l_special_year := pay_balance_pkg.get_value(l_def_bal_id
4890: ,csr_np_rec.np_assignment_action_id,null,null,context_rec.context_id,context_rec.value,null,null);
4891: --FND_FILE.PUT_LINE(FND_FILE.LOG, 'l_special_year'||' '||l_special_year);
4892: END IF;
4893: END IF;

Line 4929: l_non_year := pay_balance_pkg.get_value(l_def_bal_id

4925: l_def_bal_id := get_defined_balance_id (p_non_tax_bal_name,'_ASG_SIT_YTD');
4926: --FND_FILE.PUT_LINE(FND_FILE.LOG, 'l_def_bal_id'||' '||l_def_bal_id);
4927:
4928: IF l_def_bal_id IS NOT NULL THEN
4929: l_non_year := pay_balance_pkg.get_value(l_def_bal_id
4930: ,csr_np_rec.np_assignment_action_id,null,null,context_rec.context_id,context_rec.value,null,null);
4931: --FND_FILE.PUT_LINE(FND_FILE.LOG, 'l_non_year'||' '||l_non_year);
4932: END IF;
4933: END IF;

Line 4963: l_sum_year := pay_balance_pkg.get_value(l_def_bal_id

4959: l_def_bal_id := get_defined_balance_id (p_balance_name,'_ASG_SIT_YTD');
4960: --FND_FILE.PUT_LINE(FND_FILE.LOG, 'l_def_bal_id'||' '||l_def_bal_id);
4961:
4962: IF l_def_bal_id IS NOT NULL THEN
4963: l_sum_year := pay_balance_pkg.get_value(l_def_bal_id
4964: ,csr_np_rec.np_assignment_action_id,null,null,context_rec.context_id,context_rec.value,null,null);
4965: --FND_FILE.PUT_LINE(FND_FILE.LOG, 'l_sum_year'||' '||l_sum_year);
4966: END IF;
4967: END IF;

Line 5224: l_standard_year := pay_balance_pkg.get_value(l_def_bal_id

5220: --IF l_flag=1 THEN
5221: l_def_bal_id := get_defined_balance_id (p_standard_bal_name,'_ASG_YTD');
5222: --FND_FILE.PUT_LINE(FND_FILE.LOG, 'l_def_bal_id'||' '||l_def_bal_id);
5223: IF l_def_bal_id IS NOT NULL THEN
5224: l_standard_year := pay_balance_pkg.get_value(l_def_bal_id
5225: ,csr_np_rec.np_assignment_action_id);
5226: END IF;
5227: IF /*l_standard_year=0 and*/ p_standard_bal_name = 'Retro Standard Taxable Income' THEN
5228: l_def_bal_id := get_defined_balance_id ('Retro Standard Taxable Income Current Quarter'

Line 5231: l_standard_year := l_standard_year + pay_balance_pkg.get_value(l_def_bal_id,csr_np_rec.np_assignment_action_id);

5227: IF /*l_standard_year=0 and*/ p_standard_bal_name = 'Retro Standard Taxable Income' THEN
5228: l_def_bal_id := get_defined_balance_id ('Retro Standard Taxable Income Current Quarter'
5229: ,'_ASG_YTD');
5230: IF l_def_bal_id IS NOT NULL THEN
5231: l_standard_year := l_standard_year + pay_balance_pkg.get_value(l_def_bal_id,csr_np_rec.np_assignment_action_id);
5232: END IF;
5233: END IF;
5234: l_standard_year := l_standard_year * p_multiply_factor;
5235: l_def_bal_id := get_defined_balance_id (p_standard_bal_name,'_ASG_PTD');

Line 5238: l_standard_ptd := pay_balance_pkg.get_value(l_def_bal_id

5234: l_standard_year := l_standard_year * p_multiply_factor;
5235: l_def_bal_id := get_defined_balance_id (p_standard_bal_name,'_ASG_PTD');
5236: --FND_FILE.PUT_LINE(FND_FILE.LOG, 'l_def_bal_id'||' '||l_def_bal_id);
5237: IF l_def_bal_id IS NOT NULL THEN
5238: l_standard_ptd := pay_balance_pkg.get_value(l_def_bal_id
5239: ,csr_np_rec.np_assignment_action_id);
5240: END IF;
5241: IF l_standard_ptd=0 and p_standard_bal_name = 'Retro Standard Taxable Income' THEN
5242: l_def_bal_id := get_defined_balance_id ('Retro Standard Taxable Income Current Quarter','_ASG_PTD');

Line 5244: l_standard_ptd := pay_balance_pkg.get_value(l_def_bal_id

5240: END IF;
5241: IF l_standard_ptd=0 and p_standard_bal_name = 'Retro Standard Taxable Income' THEN
5242: l_def_bal_id := get_defined_balance_id ('Retro Standard Taxable Income Current Quarter','_ASG_PTD');
5243: IF l_def_bal_id IS NOT NULL THEN
5244: l_standard_ptd := pay_balance_pkg.get_value(l_def_bal_id
5245: ,csr_np_rec.np_assignment_action_id);
5246: END IF;
5247: END IF;
5248: -- END IF;

Line 5286: l_special_year := pay_balance_pkg.get_value(l_def_bal_id,csr_np_rec.np_assignment_action_id);

5282:
5283: l_def_bal_id := get_defined_balance_id (p_special_bal_name,'_ASG_YTD');
5284: --FND_FILE.PUT_LINE(FND_FILE.LOG, 'l_def_bal_id'||' '||l_def_bal_id);
5285: IF l_def_bal_id IS NOT NULL THEN
5286: l_special_year := pay_balance_pkg.get_value(l_def_bal_id,csr_np_rec.np_assignment_action_id);
5287: --FND_FILE.PUT_LINE(FND_FILE.LOG, 'l_special_year'||' '||l_special_year);
5288: END IF;
5289: l_special_year := l_special_year * p_multiply_factor;
5290:

Line 5295: l_special_ptd := pay_balance_pkg.get_value(l_def_bal_id

5291: l_def_bal_id := get_defined_balance_id (p_special_bal_name,'_ASG_PTD');
5292: --FND_FILE.PUT_LINE(FND_FILE.LOG, 'l_def_bal_id'||' '||l_def_bal_id);
5293:
5294: IF l_def_bal_id IS NOT NULL THEN
5295: l_special_ptd := pay_balance_pkg.get_value(l_def_bal_id
5296: ,csr_np_rec.np_assignment_action_id);
5297: --FND_FILE.PUT_LINE(FND_FILE.LOG, 'l_special_year'||' '||l_special_year);
5298: END IF;
5299: --

Line 5333: l_sum_year := pay_balance_pkg.get_value(l_def_bal_id,csr_np_rec.np_assignment_action_id);

5329: l_def_bal_id := get_defined_balance_id (p_balance_name,'_ASG_YTD');
5330: --FND_FILE.PUT_LINE(FND_FILE.LOG, 'l_def_bal_id'||' '||l_def_bal_id);
5331:
5332: IF l_def_bal_id IS NOT NULL THEN
5333: l_sum_year := pay_balance_pkg.get_value(l_def_bal_id,csr_np_rec.np_assignment_action_id);
5334: --FND_FILE.PUT_LINE(FND_FILE.LOG, 'l_sum_year'||' '||l_sum_year);
5335: l_sum_year := l_sum_year * p_multiply_factor;
5336: END IF;
5337: END IF;