DBA Data[Home] [Help]

APPS.PER_PERRPFP3_XMLP_PKG dependencies on PER_PERIODS_OF_SERVICE

Line 83: hr_reports.get_desc_flex_context('PER','PER_PERIODS_OF_SERVICE',

79: end if;
80:
81:
82:
83: hr_reports.get_desc_flex_context('PER','PER_PERIODS_OF_SERVICE',
84: 'a',v_title,v_label_expr,v_column_expr);
85: if v_column_expr is not null then
86: c_per_serv_df_details := v_column_expr;
87: c_per_serv_df_label := v_label_expr;

Line 488: from per_periods_of_service pps,

484: v_detailcount number(10);
485: begin
486: select count(*)
487: into v_detailcount
488: from per_periods_of_service pps,
489: per_all_people_f peo
490: where pps.person_id = p_person_id
491: and pps.business_group_id = p_business_group_id
492: and pps.termination_accepted_person_id = peo.person_id(+)