[Home] [Help]
428:
429: EXCEPTION
430: WHEN OTHERS THEN
431: -- Return cursor that selects no rows
432: p_sql := 'select 1 from dual where to_char(:payroll_action_id) = dummy';
433:
434: END RANGE_CODE;
435:
436: ---------------------------------- PROCEDURE ASSIGNMENT_ACTION_CODE ----------------------------------------------------------------
558: IF l_prepay_action_id <> rec_prepaid_assignments.prepaid_action_id THEN
559:
560: SELECT pay_assignment_actions_s.NEXTVAL
561: INTO l_actid
562: FROM dual;
563: --
564: g_index_assact := g_index_assact + 1;
565: g_lock_table(g_index_assact).archive_assact_id := l_actid; /* For Element archival */
566:
2351: -- Case for Group by or NOT
2352: -- Segemnt 6 is allowed here, as it makes sense.
2353: IF ( rec_group_by.ORG_INFORMATION6 = 'N' or (rec_group_by.ORG_INFORMATION3 IS NULL) )
2354: THEN
2355: -- This csae is for individual representation of each element.
2356: -- Unit and unit price should be absent.
2357: FOR csr_result_rec IN csr_result_value(g_element_table(l_index).input_value_id
2358: ,g_element_table(l_index).element_type_id
2359: ,p_assignment_action_id)
3501: /* pgopal - Bug 5747199,hourly/salaried issue fix*/
3502:
3503: /*SELECT decode (l_period_type, 'Calendar Month', l_income_from_hol_Pay_sal, l_income_from_hol_Pay_hr)
3504: INTO l_income_from_hol_Pay
3505: FROM dual ;*/
3506:
3507: l_hourly_salaried := pay_dk_general.get_hour_sal_flag(p_assignment_id,p_effective_date);
3508:
3509: IF l_hourly_salaried IS NULL THEN
3515: END IF ;
3516:
3517: SELECT decode (l_hourly_salaried, 'S', l_income_from_hol_Pay_sal, l_income_from_hol_Pay_hr)
3518: INTO l_income_from_hol_Pay
3519: FROM dual ;
3520:
3521:
3522: -- l_emp_taxable_base_asg_ptd changed for Holiday Pay Changes
3523: -- l_emp_taxable_base_asg_ptd := g_bal_val(16).bal_val ;
3558: ,'Bi-Week',g_tax_card_tab(6).screen_entry_val
3559: ,'Week',g_tax_card_tab(7).screen_entry_val
3560: ,'Lunar Month',fnd_number.number_to_canonical(round(fnd_number.canonical_to_number(g_tax_card_tab(5).screen_entry_val)*12/13))) /*10262139 fix*/
3561: INTO l_tax_deduction
3562: FROM dual ;
3563:
3564: -- l_calc_holiday_pay_asg_ytd := g_bal_val(9).bal_val ;
3565:
3566: -- g_bal_val(9).bal_val => 'HOLIDAY_ACCRUAL_AMOUNT_ASG_YTD' -- FOR Calculated holiday pay ytd (Salaried)
3572: 'Calendar Month',
3573: g_bal_val(9).bal_val ,
3574: g_bal_val(18).bal_val)
3575: INTO l_calc_holiday_pay_asg_ytd
3576: FROM dual ;*/
3577:
3578: SELECT decode (l_hourly_salaried, 'S',
3579: g_bal_val(9).bal_val ,
3580: g_bal_val(18).bal_val)
3578: SELECT decode (l_hourly_salaried, 'S',
3579: g_bal_val(9).bal_val ,
3580: g_bal_val(18).bal_val)
3581: INTO l_calc_holiday_pay_asg_ytd
3582: FROM dual ;
3583:
3584: /*
3585: SELECT decode (l_period_type ,
3586: 'Calendar Month',
3586: 'Calendar Month',
3587: 707 ,
3588: 808 )
3589: INTO l_calc_holiday_pay_asg_ytd
3590: FROM dual ;
3591: */
3592:
3593: -- fnd_file.put_line(fnd_file.log,'after the select decode');
3594:
4138:
4139:
4140: IF ( rec_group_by.ORG_INFORMATION6 = 'N' or (rec_group_by.ORG_INFORMATION3 IS NULL) )
4141: THEN
4142: -- This case is for individual representation of each element.
4143: -- unit and unit price should be absent.
4144: -- fnd_file.put_line(fnd_file.log,'p_assignment_action_id'||p_assignment_action_id);
4145:
4146: FOR csr_result_rec IN csr_result_value(csr_rec.input_value_id ,csr_rec.element_type_id ,p_assignment_action_id)
4404: -- Segemnt 6 is allowed here, as it makes sense.
4405:
4406: IF ( rec_group_by.ORG_INFORMATION6 = 'N' or (rec_group_by.ORG_INFORMATION3 IS NULL) )
4407: THEN
4408: -- This csae iis for individual representation of each element.
4409: -- unit and unit price should be absent.
4410:
4411: FOR csr_result_rec IN csr_result_value(csr_rec.input_value_id ,csr_rec.element_type_id ,p_assignment_action_id)
4412: LOOP