eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PAY_JP_ISDF_SS_PKG dependencies on PAY_ASSIGNMENT_ACTIONS

Line 53: pay_assignment_actions paa,

49: pact.submission_period_status,
50: pact.submission_start_date,
51: pact.submission_end_date
52: from pay_jp_isdf_assact_v assact,
53: pay_assignment_actions paa,
54: pay_jp_isdf_pact_v pact
55: where assact.action_information_id = p_action_information_id
56: and paa.assignment_action_id = assact.assignment_action_id
57: and pact.payroll_action_id = paa.payroll_action_id;

Line 191: pay_assignment_actions paa,

187: ppa.payroll_action_id,
188: ppa.business_group_id,
189: ppa.effective_date
190: from pay_jp_isdf_assact_v pjia,
191: pay_assignment_actions paa,
192: pay_payroll_actions ppa
193: where pjia.action_information_id = p_action_information_id
194: and paa.assignment_action_id = pjia.assignment_action_id
195: and ppa.payroll_action_id = paa.payroll_action_id;

Line 1481: from pay_assignment_actions paa

1477: --
1478: cursor csr_pact
1479: is
1480: select paa.payroll_action_id
1481: from pay_assignment_actions paa
1482: where paa.assignment_action_id = l_assact_rec.assignment_action_id;
1483: --
1484: begin
1485: --

Line 2939: from pay_assignment_actions paa,

2935: select /* +ORDERED */
2936: ppa.payroll_action_id,
2937: ppa.business_group_id,
2938: ppa.effective_date
2939: from pay_assignment_actions paa,
2940: pay_payroll_actions ppa
2941: where paa.assignment_action_id = p_assignment_action_id
2942: and ppa.payroll_action_id = paa.payroll_action_id;
2943: --

Line 4028: from pay_assignment_actions paa,

4024: select /* +ORDERED */
4025: ppa.payroll_action_id,
4026: ppa.business_group_id,
4027: ppa.effective_date
4028: from pay_assignment_actions paa,
4029: pay_payroll_actions ppa
4030: where paa.assignment_action_id = p_rec.assignment_action_id
4031: and ppa.payroll_action_id = paa.payroll_action_id;
4032: --

Line 5803: from pay_assignment_actions paa,

5799: assact.action_information_id,
5800: assact.object_version_number,
5801: pp.full_name,
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

Line 5888: from pay_assignment_actions paa,

5884: assact.action_information_id,
5885: assact.object_version_number,
5886: pp.full_name,
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

Line 5974: from pay_assignment_actions paa,

5970: assact.action_information_id,
5971: assact.object_version_number,
5972: pp.full_name,
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

Line 6068: from pay_assignment_actions paa,

6064: assact.action_information_id,
6065: assact.object_version_number,
6066: pp.full_name,
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