APPS.PAY_NO_SUPPORT_ORDER dependencies on DUAL

Line 237: and rownum=1)) from dual;

233: (select eei_information1 from pay_element_type_extra_info petei
234: where petei.information_type='NO_ELEMENT_CODES'
235: and element_type_id = p_ele_type_id
236: and eei_information2 is null
237: and rownum=1)) from dual;
238:
239:
240: -- fetch the element details of 'Wage Attachment Support Order'
241:

Line 355: /* SELECT pay_no_emp_cont.get_defined_balance_id('Total Pay','_ASG_PTD') INTO l_def_bal_id FROM dual ; */

351: /* Bug Fix 5110016 : TOTAL_PAY_ASG_PTD replaced by WAGE_ATTACHMENT_SUPPORT_ORDER_BASE_ASG_PTD
352: to be used as basis for Support Order Calculation */
353:
354: -- get the defined balance id for the deduction balance of waso = TOTAL_PAY_ASG_PTD
355: /* SELECT pay_no_emp_cont.get_defined_balance_id('Total Pay','_ASG_PTD') INTO l_def_bal_id FROM dual ; */
356:
357: -- deduction balance of waso now changed to WAGE_ATTACHMENT_SUPPORT_ORDER_BASE_ASG_PTD
358: SELECT pay_no_emp_cont.get_defined_balance_id('Wage Attachment Support Order Base','_ASG_PTD') INTO l_def_bal_id FROM dual ;
359:

Line 358: SELECT pay_no_emp_cont.get_defined_balance_id('Wage Attachment Support Order Base','_ASG_PTD') INTO l_def_bal_id FROM dual ;

354: -- get the defined balance id for the deduction balance of waso = TOTAL_PAY_ASG_PTD
355: /* SELECT pay_no_emp_cont.get_defined_balance_id('Total Pay','_ASG_PTD') INTO l_def_bal_id FROM dual ; */
356:
357: -- deduction balance of waso now changed to WAGE_ATTACHMENT_SUPPORT_ORDER_BASE_ASG_PTD
358: SELECT pay_no_emp_cont.get_defined_balance_id('Wage Attachment Support Order Base','_ASG_PTD') INTO l_def_bal_id FROM dual ;
359:
360: OPEN csr_waso_deatils (l_ele_type_id) ;
361: FETCH csr_waso_deatils INTO ipv_third_party ,ipv_amount , ipv_percent ,ipv_ref_num , ipv_pay_value ;
362: CLOSE csr_waso_deatils ;

Line 645: SELECT pay_assignment_actions_s.NEXTVAL INTO l_actid FROM dual;

641: OPEN csr_tax_mun_id (rec_asg.asg_act_id , rec_asg.asg_id );
642: FETCH csr_tax_mun_id INTO l_tax_mun_id ;
643: CLOSE csr_tax_mun_id ;
644:
645: SELECT pay_assignment_actions_s.NEXTVAL INTO l_actid FROM dual;
646:
647: -- Create the archive assignment action
648: hr_nonrun_asact.insact(l_actid ,rec_asg.asg_id ,p_payroll_action_id ,p_chunk ,NULL);
649:

Line 972: from dual;

968:
969: -- to fetch the balance value of DEDUCTION BASIS balance
970: select pay_balance_pkg.get_value(ele_info.def_bal_id , rec_info.main_asg_act_id)
971: into l_dedn_basis
972: from dual;
973:
974:
975: l_third_party_dest_acc := substr(l_third_party_dest_acc,1,4)||'.'||
976: substr(l_third_party_dest_acc,5,2)||'.'||