DBA Data[Home] [Help]

APPS.PAY_JP_ISDF_SS_PKG dependencies on PER_ALL_PEOPLE_F

Line 5806: per_all_people_f pp

5802: pa.assignment_number
5803: from pay_assignment_actions paa,
5804: pay_jp_isdf_assact_v assact,
5805: per_all_assignments_f pa,
5806: per_all_people_f pp
5807: where paa.payroll_action_id = p_payroll_action_id
5808: and paa.action_status = 'C'
5809: and assact.assignment_action_id = paa.assignment_action_id
5810: and assact.transaction_status = 'N'

Line 5891: per_all_people_f pp

5887: pa.assignment_number
5888: from pay_assignment_actions paa,
5889: pay_jp_isdf_assact_v assact,
5890: per_all_assignments_f pa,
5891: per_all_people_f pp
5892: where paa.payroll_action_id = p_payroll_action_id
5893: and paa.action_status = 'C'
5894: and assact.assignment_action_id = paa.assignment_action_id
5895: and assact.transaction_status = 'F'

Line 5977: per_all_people_f pp

5973: pa.assignment_number
5974: from pay_assignment_actions paa,
5975: pay_jp_isdf_assact_v assact,
5976: per_all_assignments_f pa,
5977: per_all_people_f pp
5978: where paa.payroll_action_id = p_payroll_action_id
5979: and paa.action_status = 'C'
5980: and assact.assignment_action_id = paa.assignment_action_id
5981: and assact.transaction_status = 'A'

Line 6071: per_all_people_f pp

6067: pa.assignment_number
6068: from pay_assignment_actions paa,
6069: pay_jp_isdf_assact_v assact,
6070: per_all_assignments_f pa,
6071: per_all_people_f pp
6072: where paa.payroll_action_id = p_payroll_action_id
6073: and paa.action_status = 'C'
6074: and assact.assignment_action_id = paa.assignment_action_id
6075: and assact.transaction_status = 'A'