APPS.PYUSEXC dependencies on PAY_PAYROLL_ACTIONS

Line 73: pay_payroll_actions PACT

69:
70: select TP.end_date + 1
71: into l_return_val
72: from per_time_periods TP,
73: pay_payroll_actions PACT
74: where PACT.payroll_action_id = p_pactid
75: and PACT.payroll_id = TP.payroll_id
76: and p_date between TP.start_date and TP.end_date;
77:

Line 264: FROM pay_payroll_actions PACT,

260:
261: ELSIF p_dimension_name like '%Fiscal Quarter to Date' THEN
262: SELECT fnd_date.canonical_to_date(org_information11)
263: INTO l_beg_of_fiscal_year
264: FROM pay_payroll_actions PACT,
265: hr_organization_information HOI
266: WHERE UPPER(HOI.org_information_context) = 'BUSINESS GROUP INFORMATION'
267: AND HOI.organization_id = PACT.business_group_id
268: AND PACT.payroll_action_id = p_owner_payroll_action_id;

Line 276: FROM pay_payroll_actions PACT,

272:
273: ELSIF p_dimension_name like '%Fiscal Year to Date' THEN
274: SELECT fnd_date.canonical_to_date(org_information11)
275: INTO l_beg_of_fiscal_year
276: FROM pay_payroll_actions PACT,
277: hr_organization_information HOI
278: WHERE UPPER(HOI.org_information_context) = 'BUSINESS GROUP INFORMATION'
279: AND HOI.organization_id = PACT.business_group_id
280: AND PACT.payroll_action_id = p_owner_payroll_action_id;

Line 357: FROM pay_payroll_actions PACT,

353:
354: ELSIF p_dimension_name like '%Fiscal Quarter to Date' THEN
355: SELECT fnd_date.canonical_to_date(org_information11)
356: INTO l_beg_of_fiscal_year
357: FROM pay_payroll_actions PACT,
358: hr_organization_information HOI
359: WHERE UPPER(HOI.org_information_context) = 'BUSINESS GROUP INFORMATION'
360: AND HOI.organization_id = PACT.business_group_id
361: AND PACT.payroll_action_id = p_owner_payroll_action_id;

Line 369: FROM pay_payroll_actions PACT,

365:
366: ELSIF p_dimension_name like '%Fiscal Year to Date' THEN
367: SELECT fnd_date.canonical_to_date(org_information11)
368: INTO l_beg_of_fiscal_year
369: FROM pay_payroll_actions PACT,
370: hr_organization_information HOI
371: WHERE UPPER(HOI.org_information_context) = 'BUSINESS GROUP INFORMATION'
372: AND HOI.organization_id = PACT.business_group_id
373: AND PACT.payroll_action_id = p_owner_payroll_action_id;

Line 422: ,pay_payroll_actions ppa

418: cursor c_asg_data(cp_asg_action in number) is
419: select nvl(ppa.date_earned, ppa.effective_date)
420: ,paa.assignment_id
421: from pay_assignment_actions paa
422: ,pay_payroll_actions ppa
423: where paa.assignment_action_id = cp_asg_action
424: and ppa.payroll_action_id = paa.payroll_Action_id;
425:
426: cursor c_td_start_date(cp_time_definition_id number