APPS.HR_PERSON_RECORD dependencies on DUAL

Line 2704: INTO p_person(j).ABSENCE(P_CNT) FROM DUAL;

2700: P_Net_Entitlement => L_Entitlement
2701: );
2702: SELECT ACCRUAL_DETAILS.ACCRUAL_PLAN_NAME,L_ENTITLEMENT,ACCRUAL_DETAILS.ACCRUAL_UNITS_OF_MEASURE_NAME,
2703: TO_CHAR(p_srch_filter_tbl.p_srch_dt(j),'YYYY-MM-DD')
2704: INTO p_person(j).ABSENCE(P_CNT) FROM DUAL;
2705: p_cnt := p_cnt + 1;
2706: end loop;
2707:
2708: --p_error := p_error||'after selecting the Absence||';

Line 2892: from dual ;

2888: if (p_netpay_bal_id is not null) and (p_latest_action_id is not null)
2889: then
2890: select pay_balance_pkg.get_value(p_netpay_bal_id,p_latest_action_id)
2891: into p_person(j).payroll(p_cnt).TOTAL_NETPAY_YTD
2892: from dual ;
2893: end if;
2894:
2895: -- fetch the NI YTD
2896: if(p_def_bal_id is not null) and (p_latest_action_id is not null)

Line 2900: from dual;

2896: if(p_def_bal_id is not null) and (p_latest_action_id is not null)
2897: then
2898: select pay_balance_pkg.get_value(p_def_bal_id,p_latest_action_id)
2899: into p_person(j).payroll(p_cnt).NI_YTD
2900: from dual;
2901: end if;
2902:
2903:
2904: p_cnt := p_cnt+1;