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 48: pay_assignment_actions paa,

44: pact.submission_period_status,
45: pact.submission_start_date,
46: pact.submission_end_date
47: from pay_jp_isdf_assact_v assact,
48: pay_assignment_actions paa,
49: pay_jp_isdf_pact_v pact
50: where assact.action_information_id = p_action_information_id
51: and paa.assignment_action_id = assact.assignment_action_id
52: and pact.payroll_action_id = paa.payroll_action_id;

Line 186: pay_assignment_actions paa,

182: ppa.payroll_action_id,
183: ppa.business_group_id,
184: ppa.effective_date
185: from pay_jp_isdf_assact_v pjia,
186: pay_assignment_actions paa,
187: pay_payroll_actions ppa
188: where pjia.action_information_id = p_action_information_id
189: and paa.assignment_action_id = pjia.assignment_action_id
190: and ppa.payroll_action_id = paa.payroll_action_id;

Line 1080: from pay_assignment_actions paa

1076: --
1077: cursor csr_pact
1078: is
1079: select paa.payroll_action_id
1080: from pay_assignment_actions paa
1081: where paa.assignment_action_id = l_assact_rec.assignment_action_id;
1082: --
1083: begin
1084: --

Line 2403: from pay_assignment_actions paa,

2399: select /* +ORDERED */
2400: ppa.payroll_action_id,
2401: ppa.business_group_id,
2402: ppa.effective_date
2403: from pay_assignment_actions paa,
2404: pay_payroll_actions ppa
2405: where paa.assignment_action_id = p_assignment_action_id
2406: and ppa.payroll_action_id = paa.payroll_action_id;
2407: --

Line 3361: from pay_assignment_actions paa,

3357: select /* +ORDERED */
3358: ppa.payroll_action_id,
3359: ppa.business_group_id,
3360: ppa.effective_date
3361: from pay_assignment_actions paa,
3362: pay_payroll_actions ppa
3363: where paa.assignment_action_id = p_rec.assignment_action_id
3364: and ppa.payroll_action_id = paa.payroll_action_id;
3365: --

Line 4877: from pay_assignment_actions paa,

4873: assact.action_information_id,
4874: assact.object_version_number,
4875: pp.full_name,
4876: pa.assignment_number
4877: from pay_assignment_actions paa,
4878: pay_jp_isdf_assact_v assact,
4879: per_all_assignments_f pa,
4880: per_all_people_f pp
4881: where paa.payroll_action_id = p_payroll_action_id

Line 4962: from pay_assignment_actions paa,

4958: assact.action_information_id,
4959: assact.object_version_number,
4960: pp.full_name,
4961: pa.assignment_number
4962: from pay_assignment_actions paa,
4963: pay_jp_isdf_assact_v assact,
4964: per_all_assignments_f pa,
4965: per_all_people_f pp
4966: where paa.payroll_action_id = p_payroll_action_id

Line 5048: from pay_assignment_actions paa,

5044: assact.action_information_id,
5045: assact.object_version_number,
5046: pp.full_name,
5047: pa.assignment_number
5048: from pay_assignment_actions paa,
5049: pay_jp_isdf_assact_v assact,
5050: per_all_assignments_f pa,
5051: per_all_people_f pp
5052: where paa.payroll_action_id = p_payroll_action_id

Line 5142: from pay_assignment_actions paa,

5138: assact.action_information_id,
5139: assact.object_version_number,
5140: pp.full_name,
5141: pa.assignment_number
5142: from pay_assignment_actions paa,
5143: pay_jp_isdf_assact_v assact,
5144: per_all_assignments_f pa,
5145: per_all_people_f pp
5146: where paa.payroll_action_id = p_payroll_action_id