APPS.PAY_JP_DEF_REPORT_PKG dependencies on PAY_JP_DEF_DEP_V

Line 833: from pay_jp_def_dep_v pjdd

829: pjdd.change_date,
830: pjdd.change_reason,
831: pjdd.disability_type,
832: pjdd.disability_details
833: from pay_jp_def_dep_v pjdd
834: where pjdd.assignment_action_id = p_assignment_action_id
835: and pjdd.contact_type = 'S'
836: and pjdd.status <> 'D';
837: --

Line 853: from pay_jp_def_dep_v pjdd

849: pjdd.change_date,
850: pjdd.change_reason,
851: pjdd.disability_type,
852: pjdd.disability_details
853: from pay_jp_def_dep_v pjdd
854: where pjdd.assignment_action_id = p_assignment_action_id
855: and pjdd.contact_type <> 'S'
856: and pjdd.status <> 'D'
857: and nvl(pjdd.dep_type,'0') <> '5'

Line 918: from pay_jp_def_dep_v pjdd

914: pjdd.change_date,
915: pjdd.change_reason,
916: pjdd.disability_type,
917: pjdd.disability_details
918: from pay_jp_def_dep_v pjdd
919: where pjdd.assignment_action_id = p_assignment_action_id
920: and pjdd.contact_type <> 'S'
921: and nvl(pjdd.dep_type,'0') = '5'
922: and pjdd.status <> 'D'