APPS.PAY_IE_P45_ARCHIVE dependencies on PAY_ACTION_CONTEXTS

Line 1057: FROM pay_action_contexts pac,

1053: pac.CONTEXT_ID,
1054: pac.CONTEXT_VALUE,
1055: null,
1056: null))
1057: FROM pay_action_contexts pac,
1058: pay_assignment_actions pas,
1059: pay_payroll_actions ppa
1060: WHERE substr(pac.Context_Value,1,4) = p_context_value
1061: AND pac.assignment_id in (select papf.assignment_id

Line 1554: , pay_action_contexts ACX_PROCESS_ID

1550: , per_time_periods BPTP
1551: , pay_run_results PROCESS_RR
1552: , pay_run_result_values PROCESS
1553: , pay_input_values_f PROCESS_IV
1554: , pay_action_contexts ACX_PROCESS_ID
1555: , ff_contexts CON_PROCESS_ID
1556: where BAL_ASSACT.assignment_action_id = p_source_id
1557: and BAL_ASSACT.payroll_action_id = BACT.payroll_action_id
1558: and FEED.balance_type_id +0 = p_balance_type_id

Line 1608: FROM pay_action_contexts pac,pay_assignment_actions pas,

1604: -- payroll runs having prsi contribution class as A
1605: -- in the same tax year for which the archive is run
1606: /*CURSOR Cur_Act_Contexts IS
1607: SELECT pac.Context_ID,pac.Context_Value,pac.Assignment_action_id
1608: FROM pay_action_contexts pac,pay_assignment_actions pas,
1609: pay_payroll_actions ppa,pay_payroll_actions appa
1610: WHERE pac.Context_Value = 'IE_A'
1611: AND pac.assignment_id = p_assignment_id
1612: AND pas.assignment_action_id = pac.assignment_action_id

Line 1617: FROM pay_action_contexts

1613: AND ppa.payroll_action_id = pas.payroll_action_id
1614: And appa.payroll_action_id = g_archive_pact
1615: AND to_char(appa.date_earned,'YYYY') = to_char(ppa.date_earned,'YYYY')
1616: AND pac.assignment_action_id = (SELECT MAX(assignment_action_id)
1617: FROM pay_action_contexts
1618: WHERE Context_Value = 'IE_A'
1619: AND assignment_id = p_assignment_id);
1620: v_Cur_Act_Contexts Cur_Act_Contexts%ROWTYPE;*/
1621: --Bug 3079945 Start

Line 1666: FROM pay_action_contexts pac,

1662: pac.CONTEXT_ID,
1663: pac.CONTEXT_VALUE,
1664: null,
1665: null))
1666: FROM pay_action_contexts pac,
1667: pay_assignment_actions pas,
1668: pay_payroll_actions ppa
1669: WHERE pac.Context_Value like 'IE_A%'
1670: AND pac.assignment_id in (select papf.assignment_id

Line 1729: FROM pay_action_contexts pac,

1725: pac.CONTEXT_ID,
1726: pac.CONTEXT_VALUE,
1727: null,
1728: null))
1729: FROM pay_action_contexts pac,
1730: pay_assignment_actions pas,
1731: pay_payroll_actions ppa
1732: WHERE pac.Context_Value like 'IE_A%'
1733: AND pac.assignment_id in (select paaf.assignment_id