APPS.PAY_GB_RTI_FPS_ARCHIVE dependencies on HR_SOFT_CODING_KEYFLEX

Line 290: hr_soft_coding_keyflex sck

286: cursor csr_asg is
287: select paaf.assignment_id
288: from per_all_assignments_f paaf,
289: pay_payrolls_f pay,
290: hr_soft_coding_keyflex sck
291: where paaf.person_id = (select distinct person_id from per_all_assignments_f where ASSIGNMENT_ID =p_assignment_id)
292: and pay.payroll_id = paaf.payroll_id
293: and pay.SOFT_CODING_KEYFLEX_ID = sck.SOFT_CODING_KEYFLEX_ID
294: and sck.SEGMENT1 = g_tax_ref

Line 4357: hr_soft_coding_keyflex flex,

4353: cursor csr_get_start_date is
4354: select paaf.effective_start_date from
4355: per_all_assignments_f paaf,
4356: pay_all_payrolls_f papf ,
4357: hr_soft_coding_keyflex flex,
4358: per_assignment_status_types past
4359: where paaf.assignment_id = asg_id and paaf.effective_end_date = eff_date - 1
4360: and papf.payroll_id = paaf.payroll_id
4361: and flex.SOFT_CODING_KEYFLEX_ID = papf.SOFT_CODING_KEYFLEX_ID

Line 6677: hr_soft_coding_keyflex flex

6673: and ppa.action_type in ('P','U')
6674: and ppa.action_status ='C'
6675: and ppa.payroll_id in (select distinct payroll_id
6676: from pay_all_payrolls_f papf,
6677: hr_soft_coding_keyflex flex
6678: where upper(flex.segment1) = c_tax_ref
6679: and flex.SOFT_CODING_KEYFLEX_ID = papf.SOFT_CODING_KEYFLEX_ID)
6680: minus
6681: select distinct pre_payment_payroll_action_id from pay_gb_bacs_fps;

Line 7297: hr_soft_coding_keyflex flex

7293: pay_assignment_actions act1, --Prepayments
7294: pay_action_interlocks pai, --Prepayments
7295: per_all_assignments_f as1,
7296: pay_all_payrolls_f papf ,
7297: hr_soft_coding_keyflex flex
7298: WHERE as1.person_id = p_person_id --58105
7299: AND appa.action_type IN ('R','Q','V','B') -- Payroll Run or Quickpay Run
7300: AND act.payroll_action_id = appa.payroll_action_id
7301: AND act.source_action_id IS NULL