DBA Data[Home] [Help]

APPS.PAY_P45_PKG dependencies on PAY_PAYROLLS_F

Line 279: g_payroll_id pay_payrolls_f.payroll_id%TYPE;

275: g_asg_creation_cache_populated BOOLEAN := FALSE;
276: g_asg_process_cache_populated BOOLEAN := FALSE;
277: g_fnd_rep_request_msg VARCHAR2(2000):=' ';
278: -- SRS Params
279: g_payroll_id pay_payrolls_f.payroll_id%TYPE;
280: g_start_date DATE;
281: g_effective_date DATE;
282: g_end_date DATE;
283: g_business_group_id hr_organization_units.business_group_id%TYPE;

Line 1120: pay_payrolls_f roll,

1116: select oi.ORG_INFORMATION3,
1117: oi.ORG_INFORMATION4,
1118: ass.ASSIGNMENT_ID
1119: from hr_organization_information oi,
1120: pay_payrolls_f roll,
1121: hr_soft_coding_keyflex flex,
1122: per_assignments_f ass,
1123: fnd_sessions sess
1124: where oi.ORG_INFORMATION_CONTEXT = 'Tax Details References'

Line 2872: pay_payrolls_f roll,

2868: cursor csr_week_or_month(p_payroll_action_id NUMBER) IS
2869: SELECT decode(target.basic_period_type, 'W', 'W', 'M')
2870: FROM per_time_period_rules target ,
2871: per_time_period_types ptpt ,
2872: pay_payrolls_f roll,
2873: pay_payroll_actions pact
2874: WHERE ptpt.period_type = roll.period_type
2875: AND target.number_per_fiscal_year = ptpt.number_per_fiscal_year
2876: AND roll.payroll_id = pact.payroll_id