APPS.PAY_KR_FF_FUNCTIONS_PKG dependencies on PAY_PAYROLL_ACTIONS

Line 10: g_payroll_action_id pay_payroll_actions.payroll_action_id%TYPE;

6: type legislative_parameter is record(
7: parameter_name varchar2(255),
8: parameter_value varchar2(255));
9: type legislative_parameter_tbl is table of legislative_parameter index by binary_integer;
10: g_payroll_action_id pay_payroll_actions.payroll_action_id%TYPE;
11: g_legislative_parameter_tbl legislative_parameter_tbl;
12: g_effective_date date ; -- Bug 4674552
13: --
14: -- NI Component Global Variables.

Line 29: l_legislative_parameters pay_payroll_actions.legislative_parameters%TYPE;

25: p_default_value in varchar2,
26: p_flash_cache in varchar2) return varchar2
27: --------------------------------------------------------------------------------
28: is
29: l_legislative_parameters pay_payroll_actions.legislative_parameters%TYPE;
30: l_str pay_payroll_actions.legislative_parameters%TYPE;
31: l_pos number;
32: l_end_pos number;
33: l_parameter_name varchar2(255);

Line 30: l_str pay_payroll_actions.legislative_parameters%TYPE;

26: p_flash_cache in varchar2) return varchar2
27: --------------------------------------------------------------------------------
28: is
29: l_legislative_parameters pay_payroll_actions.legislative_parameters%TYPE;
30: l_str pay_payroll_actions.legislative_parameters%TYPE;
31: l_pos number;
32: l_end_pos number;
33: l_parameter_name varchar2(255);
34: l_parameter_value varchar2(255);

Line 40: from pay_payroll_actions

36: l_index number;
37: --
38: cursor csr_legislative_parameters is
39: select legislative_parameters
40: from pay_payroll_actions
41: where payroll_action_id = p_payroll_action_id;
42: begin
43: if p_flash_cache = 'Y'
44: or g_payroll_action_id is null

Line 1435: p_eff_date in pay_payroll_actions.effective_date%type,

1431: p_addl_tax_exem_flag in per_contact_relationships.cont_information3%type,
1432: p_addl_disabled_flag in per_contact_relationships.cont_information4%type,
1433: p_addl_exem_flag_child in per_contact_relationships.cont_information7%type,
1434: p_age_ckh_exp_flag in per_contact_relationships.cont_information8%type,
1435: p_eff_date in pay_payroll_actions.effective_date%type,
1436: p_ins_prem_exem_incl_flag in per_contact_relationships.cont_information10%type, -- Bug 4931542
1437: p_med_exp_exem_incl_flag in per_contact_relationships.cont_information12%type, -- Bug 4931542
1438: p_edu_exp_exem_incl_flag in per_contact_relationships.cont_information13%type, -- Bug 4931542
1439: p_card_exp_exem_incl_flag in per_contact_relationships.cont_information14%type, -- Bug 4931542

Line 1603: p_eff_date in pay_payroll_actions.effective_date%type

1599: p_ni in per_people_f.national_identifier%type,
1600: p_itax_dpnt_flag in per_contact_relationships.cont_information2%type,
1601: p_addl_disabled_flag in per_contact_relationships.cont_information4%type,
1602: p_age_ckh_exp_flag in per_contact_relationships.cont_information8%type,
1603: p_eff_date in pay_payroll_actions.effective_date%type
1604: ) return varchar2
1605: is
1606: begin
1607: -- Bug 5356651

Line 1688: from pay_payroll_actions ppa,

1684: cursor csr_get_ass_act_id(p_assignment_id per_assignments_f.assignment_id%type,
1685: p_effective_year varchar2)
1686: is
1687: SELECT paa.assignment_action_id ass_act_id
1688: from pay_payroll_actions ppa,
1689: pay_assignment_actions paa
1690: where paa.assignment_id = p_assignment_id
1691: and paa.action_status = 'C'
1692: and ppa.payroll_action_id = paa.payroll_action_id

Line 1777: ,pay_payroll_actions ppa

1773: SELECT upper(nvl(prrv.result_value, 'N'))
1774: FROM pay_input_values_f piv
1775: ,pay_run_result_values prrv
1776: ,pay_run_results prr
1777: ,pay_payroll_actions ppa
1778: ,pay_assignment_actions paa
1779: ,pay_element_types_f pet
1780: WHERE paa.assignment_action_id = l_assignment_action_id
1781: and ppa.payroll_action_id = paa.payroll_action_id

Line 1961: ,pay_payroll_actions ppa

1957: SELECT upper(nvl(prrv.result_value, 'N'))
1958: FROM pay_input_values_f piv
1959: ,pay_run_result_values prrv
1960: ,pay_run_results prr
1961: ,pay_payroll_actions ppa
1962: ,pay_assignment_actions paa
1963: ,pay_element_types_f pet
1964: WHERE paa.assignment_action_id = l_assignment_action_id
1965: and ppa.payroll_action_id = paa.payroll_action_id

Line 2011: ,pay_payroll_actions ppa

2007: SELECT nvl(prrv.result_value, 0)
2008: FROM pay_input_values_f piv
2009: ,pay_run_result_values prrv
2010: ,pay_run_results prr
2011: ,pay_payroll_actions ppa
2012: ,pay_assignment_actions paa
2013: ,pay_element_types_f pet
2014: WHERE paa.assignment_action_id = l_assignment_action_id
2015: and ppa.payroll_action_id = paa.payroll_action_id

Line 2063: ,pay_payroll_actions ppa

2059: SELECT upper(nvl(prrv.result_value, 'Y'))
2060: FROM pay_input_values_f piv
2061: ,pay_run_result_values prrv
2062: ,pay_run_results prr
2063: ,pay_payroll_actions ppa
2064: ,pay_assignment_actions paa
2065: ,pay_element_types_f pet
2066: WHERE paa.assignment_action_id = l_assignment_action_id
2067: and ppa.payroll_action_id = paa.payroll_action_id

Line 2113: ,pay_payroll_actions ppa

2109: SELECT nvl(fnd_date.canonical_to_date(prrv.result_value), to_date('01-01-1900','dd-mm-yyyy'))
2110: FROM pay_input_values_f piv
2111: ,pay_run_result_values prrv
2112: ,pay_run_results prr
2113: ,pay_payroll_actions ppa
2114: ,pay_assignment_actions paa
2115: ,pay_element_types_f pet
2116: WHERE paa.assignment_action_id = l_assignment_action_id
2117: and ppa.payroll_action_id = paa.payroll_action_id

Line 4160: from pay_payroll_actions ppa,

4156: l_dummy varchar2(2);
4157: --
4158: cursor csr is
4159: SELECT 'Y'
4160: from pay_payroll_actions ppa,
4161: pay_assignment_actions paa
4162: where paa.assignment_id = p_assignment_id
4163: and paa.action_status = 'C'
4164: and ppa.payroll_action_id = paa.payroll_action_id