DBA Data[Home] [Help]

APPS.PAY_JP_DEF_REPORT_PKG dependencies on PAY_JP_DEF_EMP_V

Line 309: pay_jp_def_emp_v pjde

305: from per_periods_of_service ppos,
306: per_all_assignments_f pa,
307: pay_assignment_actions paa,
308: pay_jp_def_assact_v pjda,
309: pay_jp_def_emp_v pjde
310: where ppos.person_id
311: between p_start_person_id and p_end_person_id
312: and ppos.business_group_id + 0 = g_business_group_id
313: and ppos.date_start <= g_effective_date

Line 338: pay_jp_def_emp_v pjde

334: per_all_assignments_f pa,
335: pay_assignment_actions paa,
336: hr_assignment_set_amendments hasa,
337: pay_jp_def_assact_v pjda,
338: pay_jp_def_emp_v pjde
339: where ppos.person_id
340: between p_start_person_id and p_end_person_id
341: and ppos.business_group_id + 0 = g_business_group_id
342: and ppos.date_start <= g_effective_date

Line 811: pay_jp_def_emp_v pjde

807: pjde.change_reason
808: from pay_assignment_actions paa,
809: pay_jp_def_pact_v pjdp,
810: pay_jp_def_assact_v pjda,
811: pay_jp_def_emp_v pjde
812: where paa.assignment_action_id = p_assignment_action_id
813: and pjdp.payroll_action_id = paa.payroll_action_id
814: and pjda.assignment_action_id = paa.assignment_action_id
815: and pjde.assignment_action_id = pjda.assignment_action_id

Line 2890: -- pay_jp_def_emp_v pjde

2886: -- 'select paa.rowid
2887: -- from pay_payroll_actions ppa,
2888: -- pay_assignment_actions paa,
2889: -- pay_jp_def_assact_v pjda,
2890: -- pay_jp_def_emp_v pjde
2891: -- where ppa.payroll_action_id = :pactid
2892: -- and paa.payroll_action_id = ppa.payroll_action_id
2893: -- and pjda.assignment_action_id = paa.source_action_id
2894: -- and pjde.assignment_action_id = pjda.assignment_action_id