APPS.PAY_DK_ARCHIVE dependencies on DUAL

Line 425: p_sql := 'select 1 from dual where to_char(:payroll_action_id) = dummy';

421:
422: EXCEPTION
423: WHEN OTHERS THEN
424: -- Return cursor that selects no rows
425: p_sql := 'select 1 from dual where to_char(:payroll_action_id) = dummy';
426:
427: END RANGE_CODE;
428:
429: ---------------------------------- PROCEDURE ASSIGNMENT_ACTION_CODE ----------------------------------------------------------------

Line 555: FROM dual;

551: IF l_prepay_action_id <> rec_prepaid_assignments.prepaid_action_id THEN
552:
553: SELECT pay_assignment_actions_s.NEXTVAL
554: INTO l_actid
555: FROM dual;
556: --
557: g_index_assact := g_index_assact + 1;
558: g_lock_table(g_index_assact).archive_assact_id := l_actid; /* For Element archival */
559:

Line 3034: FROM dual ;*/

3030: /* pgopal - Bug 5747199,hourly/salaried issue fix*/
3031:
3032: /*SELECT decode (l_period_type, 'Calendar Month', l_income_from_hol_Pay_sal, l_income_from_hol_Pay_hr)
3033: INTO l_income_from_hol_Pay
3034: FROM dual ;*/
3035:
3036: l_hourly_salaried := pay_dk_general.get_hour_sal_flag(p_assignment_id,p_effective_date);
3037:
3038: IF l_hourly_salaried IS NULL THEN

Line 3048: FROM dual ;

3044: END IF ;
3045:
3046: SELECT decode (l_hourly_salaried, 'S', l_income_from_hol_Pay_sal, l_income_from_hol_Pay_hr)
3047: INTO l_income_from_hol_Pay
3048: FROM dual ;
3049:
3050:
3051: -- l_emp_taxable_base_asg_ptd changed for Holiday Pay Changes
3052: -- l_emp_taxable_base_asg_ptd := g_bal_val(16).bal_val ;

Line 3089: FROM dual ;

3085: ,'Bi-Week',g_tax_card_tab(6).screen_entry_val
3086: ,'Week',g_tax_card_tab(7).screen_entry_val
3087: ,'Lunar Month',g_tax_card_tab(5).screen_entry_val) /* Changes for Lunar Payroll*/
3088: INTO l_tax_deduction
3089: FROM dual ;
3090:
3091: -- l_calc_holiday_pay_asg_ytd := g_bal_val(9).bal_val ;
3092:
3093: -- g_bal_val(9).bal_val => 'HOLIDAY_ACCRUAL_AMOUNT_ASG_YTD' -- FOR Calculated holiday pay ytd (Salaried)

Line 3103: FROM dual ;*/

3099: 'Calendar Month',
3100: g_bal_val(9).bal_val ,
3101: g_bal_val(18).bal_val)
3102: INTO l_calc_holiday_pay_asg_ytd
3103: FROM dual ;*/
3104:
3105: SELECT decode (l_hourly_salaried, 'S',
3106: g_bal_val(9).bal_val ,
3107: g_bal_val(18).bal_val)

Line 3109: FROM dual ;

3105: SELECT decode (l_hourly_salaried, 'S',
3106: g_bal_val(9).bal_val ,
3107: g_bal_val(18).bal_val)
3108: INTO l_calc_holiday_pay_asg_ytd
3109: FROM dual ;
3110:
3111: /*
3112: SELECT decode (l_period_type ,
3113: 'Calendar Month',

Line 3117: FROM dual ;

3113: 'Calendar Month',
3114: 707 ,
3115: 808 )
3116: INTO l_calc_holiday_pay_asg_ytd
3117: FROM dual ;
3118: */
3119:
3120: -- fnd_file.put_line(fnd_file.log,'after the select decode');
3121: