APPS.PAY_CN_EXC dependencies on PAY_PAYROLL_ACTIONS

Line 37: , pay_payroll_actions PACT

33: , p_date DATE
34: ) IS
35: SELECT TP.end_date + 1
36: FROM per_time_periods TP
37: , pay_payroll_actions PACT
38: WHERE PACT.payroll_action_id = p_pactid
39: AND PACT.payroll_id = TP.payroll_id
40: AND p_date BETWEEN TP.start_date AND TP.end_date;
41:

Line 256: FROM pay_payroll_actions PACT

252: l_expiry_date DATE := NULL;
253:
254: CURSOR cur_beg_of_fiscal_year ( p_owner_payroll_action_id NUMBER ) IS
255: SELECT fnd_date.canonical_to_date(org_information11)
256: FROM pay_payroll_actions PACT
257: , hr_organization_information HOI
258: WHERE UPPER(HOI.org_information_context) = 'BUSINESS GROUP INFORMATION'
259: AND HOI.organization_id = PACT.business_group_id
260: AND PACT.payroll_action_id = p_owner_payroll_action_id;

Line 390: FROM pay_payroll_actions PACT

386: l_expiry_date DATE := NULL;
387:
388: CURSOR cur_beg_of_fiscal_year ( p_owner_payroll_action_id NUMBER ) IS
389: SELECT fnd_date.canonical_to_date(org_information11)
390: FROM pay_payroll_actions PACT
391: , hr_organization_information HOI
392: WHERE UPPER(HOI.org_information_context) = 'BUSINESS GROUP INFORMATION'
393: AND HOI.organization_id = PACT.business_group_id
394: AND PACT.payroll_action_id = p_owner_payroll_action_id;