APPS.PAY_FI_EXPIRY_SUPPORT dependencies on PAY_PAYROLL_ACTIONS

Line 64: ,pay_payroll_actions PACT

60: --
61: SELECT TP.start_date
62: INTO l_period_start_date
63: FROM per_time_periods TP
64: ,pay_payroll_actions PACT
65: WHERE PACT.payroll_action_id = p_owner_payroll_action_id
66: AND PACT.payroll_id = TP.payroll_id
67: AND p_owner_effective_date BETWEEN TP.start_date AND TP.end_date;
68: --

Line 117: FROM pay_payroll_actions pact

113: --
114: CURSOR get_period_type(p_payroll_action_id NUMBER, p_dimension_name VARCHAR2) IS
115: SELECT bd.period_type
116: ,pact.business_group_id
117: FROM pay_payroll_actions pact
118: ,hr_organization_information hoi
119: ,pay_balance_dimensions bd
120: WHERE pact.payroll_action_id = p_payroll_action_id
121: AND hoi.organization_id = pact.business_group_id

Line 252: FROM pay_payroll_actions pact

248: --
249: CURSOR get_period_type(p_payroll_action_id NUMBER, p_dimension_name VARCHAR2) IS
250: SELECT bd.period_type
251: ,pact.business_group_id
252: FROM pay_payroll_actions pact
253: ,hr_organization_information hoi
254: ,pay_balance_dimensions bd
255: WHERE pact.payroll_action_id = p_payroll_action_id
256: AND hoi.organization_id = pact.business_group_id

Line 365: FROM pay_payroll_actions pact

361: --
362: CURSOR csr_info(p_payroll_action_id NUMBER, p_dimension_name VARCHAR2) IS
363: SELECT bd.period_type
364: ,pact.business_group_id
365: FROM pay_payroll_actions pact
366: ,hr_organization_information hoi
367: ,pay_balance_dimensions bd
368: WHERE pact.payroll_action_id = p_payroll_action_id
369: AND hoi.organization_id = pact.business_group_id

Line 448: FROM pay_payroll_actions pact

444: --
445: CURSOR csr_info(p_payroll_action_id NUMBER, p_dimension_name VARCHAR2) IS
446: SELECT bd.period_type
447: ,pact.business_group_id
448: FROM pay_payroll_actions pact
449: ,hr_organization_information hoi
450: ,pay_balance_dimensions bd
451: WHERE pact.payroll_action_id = p_payroll_action_id
452: AND hoi.organization_id = pact.business_group_id