APPS.PYUSEXC dependencies on PAY_PAYROLL_ACTIONS

Line 76: pay_payroll_actions PACT

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

Line 324: FROM pay_payroll_actions PACT,

320:
321: ELSIF p_dimension_name like '%Fiscal Quarter to Date' THEN
322: SELECT fnd_date.canonical_to_date(org_information11)
323: INTO l_beg_of_fiscal_year
324: FROM pay_payroll_actions PACT,
325: hr_organization_information HOI
326: WHERE UPPER(HOI.org_information_context) = 'BUSINESS GROUP INFORMATION'
327: AND HOI.organization_id = PACT.business_group_id
328: AND PACT.payroll_action_id = p_owner_payroll_action_id;

Line 336: FROM pay_payroll_actions PACT,

332:
333: ELSIF p_dimension_name like '%Fiscal Year to Date' THEN
334: SELECT fnd_date.canonical_to_date(org_information11)
335: INTO l_beg_of_fiscal_year
336: FROM pay_payroll_actions PACT,
337: hr_organization_information HOI
338: WHERE UPPER(HOI.org_information_context) = 'BUSINESS GROUP INFORMATION'
339: AND HOI.organization_id = PACT.business_group_id
340: AND PACT.payroll_action_id = p_owner_payroll_action_id;

Line 417: FROM pay_payroll_actions PACT,

413:
414: ELSIF p_dimension_name like '%Fiscal Quarter to Date' THEN
415: SELECT fnd_date.canonical_to_date(org_information11)
416: INTO l_beg_of_fiscal_year
417: FROM pay_payroll_actions PACT,
418: hr_organization_information HOI
419: WHERE UPPER(HOI.org_information_context) = 'BUSINESS GROUP INFORMATION'
420: AND HOI.organization_id = PACT.business_group_id
421: AND PACT.payroll_action_id = p_owner_payroll_action_id;

Line 429: FROM pay_payroll_actions PACT,

425:
426: ELSIF p_dimension_name like '%Fiscal Year to Date' THEN
427: SELECT fnd_date.canonical_to_date(org_information11)
428: INTO l_beg_of_fiscal_year
429: FROM pay_payroll_actions PACT,
430: hr_organization_information HOI
431: WHERE UPPER(HOI.org_information_context) = 'BUSINESS GROUP INFORMATION'
432: AND HOI.organization_id = PACT.business_group_id
433: AND PACT.payroll_action_id = p_owner_payroll_action_id;

Line 482: ,pay_payroll_actions ppa

478: cursor c_asg_data(cp_asg_action in number) is
479: select nvl(ppa.date_earned, ppa.effective_date)
480: ,paa.assignment_id
481: from pay_assignment_actions paa
482: ,pay_payroll_actions ppa
483: where paa.assignment_action_id = cp_asg_action
484: and ppa.payroll_action_id = paa.payroll_Action_id;
485:
486: cursor c_td_start_date(cp_time_definition_id number