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 1122: p_eff_date in pay_payroll_actions.effective_date%type,

1118: p_addl_tax_exem_flag in per_contact_relationships.cont_information3%type,
1119: p_addl_disabled_flag in per_contact_relationships.cont_information4%type,
1120: p_addl_exem_flag_child in per_contact_relationships.cont_information7%type,
1121: p_age_ckh_exp_flag in per_contact_relationships.cont_information8%type,
1122: p_eff_date in pay_payroll_actions.effective_date%type,
1123: p_ins_prem_exem_incl_flag in per_contact_relationships.cont_information10%type, -- Bug 4931542
1124: p_med_exp_exem_incl_flag in per_contact_relationships.cont_information12%type, -- Bug 4931542
1125: p_edu_exp_exem_incl_flag in per_contact_relationships.cont_information13%type, -- Bug 4931542
1126: p_card_exp_exem_incl_flag in per_contact_relationships.cont_information14%type, -- Bug 4931542

Line 1266: p_eff_date in pay_payroll_actions.effective_date%type

1262: p_ni in per_people_f.national_identifier%type,
1263: p_itax_dpnt_flag in per_contact_relationships.cont_information2%type,
1264: p_addl_disabled_flag in per_contact_relationships.cont_information4%type,
1265: p_age_ckh_exp_flag in per_contact_relationships.cont_information8%type,
1266: p_eff_date in pay_payroll_actions.effective_date%type
1267: ) return varchar2
1268: is
1269: begin
1270: -- Bug 5356651

Line 1347: from pay_payroll_actions ppa,

1343: cursor csr_get_ass_act_id(p_assignment_id per_assignments_f.assignment_id%type,
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

Line 1435: ,pay_payroll_actions ppa

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
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