APPS.PAY_ACTION_CONTEXTS_PKG dependencies on PAY_PAYROLL_ACTIONS

Line 48: PAY_PAYROLL_ACTIONS pa

44: SELECT ou.org_information9
45: INTO g_legislation_code
46: FROM HR_ORGANIZATION_INFORMATION ou,
47: HR_ORGANIZATION_UNITS o,
48: PAY_PAYROLL_ACTIONS pa
49: WHERE pa.payroll_action_id = p_pay_act_id
50: and o.business_group_id = pa.business_group_id
51: and ou.organization_id = o.organization_id
52: and ou.org_information_context = 'Business Group Information';

Line 73: PAY_PAYROLL_ACTIONS pa

69: p_sqlstr :=
70: 'SELECT DISTINCT
71: asg.person_id
72: FROM PER_ASSIGNMENTS_F asg,
73: PAY_PAYROLL_ACTIONS pa
74: WHERE pa.payroll_action_id = :payroll_action_id
75: and asg.business_group_id = pa.business_group_id
76: ORDER BY
77: asg.person_id';

Line 93: FROM PAY_PAYROLL_ACTIONS pa,

89: cursor csr_asg_acts(b_pay_act_id number, b_stperson number,
90: b_endperson number) is
91: SELECT DISTINCT
92: asg.assignment_id
93: FROM PAY_PAYROLL_ACTIONS pa,
94: PER_ALL_ASSIGNMENTS_F asg,
95: PER_PERIODS_OF_SERVICE pos
96: WHERE pa.payroll_action_id = b_pay_act_id
97: and asg.business_group_id = pa.business_group_id

Line 349: FROM PAY_PAYROLL_ACTIONS pa,

345: pa.action_type,
346: aat.assignment_id,
347: aat.assignment_action_id,
348: aat.tax_unit_id
349: FROM PAY_PAYROLL_ACTIONS pa,
350: PAY_ASSIGNMENT_ACTIONS aat,
351: PAY_ASSIGNMENT_ACTIONS aam
352: WHERE aam.assignment_action_id = b_asg_act_id
353: and aat.assignment_id = aam.assignment_id