APPS.PAY_KR_FF_FUNCTIONS_PKG dependencies on PAY_ASSIGNMENT_ACTIONS

Line 1348: pay_assignment_actions paa

1344: p_effective_year varchar2)
1345: is
1346: SELECT paa.assignment_action_id ass_act_id
1347: from pay_payroll_actions ppa,
1348: pay_assignment_actions paa
1349: where paa.assignment_id = p_assignment_id
1350: and paa.action_status = 'C'
1351: and ppa.payroll_action_id = paa.payroll_action_id
1352: and to_char(ppa.effective_date, 'YYYY') = p_effective_year

Line 1423: p_assignment_action_id in pay_assignment_actions.assignment_action_id%type

1419: -- Bug 7164589: Long Term Care Insurance Premium
1420: -- Bug 7228788: Added a new input parameter to the function for the Input Value Name
1421: -----------------------------------------------------------------------------------
1422: FUNCTION get_long_term_ins_skip_flag(
1423: p_assignment_action_id in pay_assignment_actions.assignment_action_id%type
1424: ,p_input_value_name in varchar2
1425: ) RETURN VARCHAR2
1426: IS
1427: --

Line 1430: CURSOR csr(l_assignment_action_id pay_assignment_actions.assignment_action_id%type, l_input_value_name varchar2) is

1426: IS
1427: --
1428: l_flag pay_run_result_values.result_value%type;
1429: -- Bug 7228788: Added a new argument for the Input Value Name to the cursor
1430: CURSOR csr(l_assignment_action_id pay_assignment_actions.assignment_action_id%type, l_input_value_name varchar2) is
1431: SELECT upper(nvl(prrv.result_value, 'N'))
1432: FROM pay_input_values_f piv
1433: ,pay_run_result_values prrv
1434: ,pay_run_results prr

Line 1436: ,pay_assignment_actions paa

1432: FROM pay_input_values_f piv
1433: ,pay_run_result_values prrv
1434: ,pay_run_results prr
1435: ,pay_payroll_actions ppa
1436: ,pay_assignment_actions paa
1437: ,pay_element_types_f pet
1438: WHERE paa.assignment_action_id = l_assignment_action_id
1439: and ppa.payroll_action_id = paa.payroll_action_id
1440: and prr.assignment_action_id = paa.assignment_action_id