eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PAY_KR_HIA_PKG dependencies on PAY_PAYROLL_ACTIONS

Line 13: report_type pay_payroll_actions.report_type%TYPE,

9: -- Global Variables
10: --
11: TYPE t_pact IS RECORD(
12: payroll_action_id NUMBER,
13: report_type pay_payroll_actions.report_type%TYPE,
14: report_qualifier pay_payroll_actions.report_qualifier%TYPE,
15: report_category pay_payroll_actions.report_category%TYPE,
16: business_group_id NUMBER,
17: effective_date date,

Line 14: report_qualifier pay_payroll_actions.report_qualifier%TYPE,

10: --
11: TYPE t_pact IS RECORD(
12: payroll_action_id NUMBER,
13: report_type pay_payroll_actions.report_type%TYPE,
14: report_qualifier pay_payroll_actions.report_qualifier%TYPE,
15: report_category pay_payroll_actions.report_category%TYPE,
16: business_group_id NUMBER,
17: effective_date date,
18: bp_hi_number varchar2(250), --3506171

Line 15: report_category pay_payroll_actions.report_category%TYPE,

11: TYPE t_pact IS RECORD(
12: payroll_action_id NUMBER,
13: report_type pay_payroll_actions.report_type%TYPE,
14: report_qualifier pay_payroll_actions.report_qualifier%TYPE,
15: report_category pay_payroll_actions.report_category%TYPE,
16: business_group_id NUMBER,
17: effective_date date,
18: bp_hi_number varchar2(250), --3506171
19: reported_date date,

Line 47: pay_payroll_actions ppa

43:
44: p_sqlstr :=
45: 'SELECT DISTINCT person_id
46: FROM per_people_f ppf,
47: pay_payroll_actions ppa
48: WHERE ppa.payroll_action_id = :payroll_action_id
49: AND ppa.business_group_id = ppf.business_group_id
50: ORDER BY ppf.person_id';
51: if g_debug then

Line 81: from pay_payroll_actions ppa

77: pay_core_utils.get_parameter('BP_HI_NUMBER',ppa.legislative_parameters) bp_hi_number, --3506171
78: fnd_date.canonical_to_date(pay_core_utils.get_parameter('REPORTED_DATE',ppa.legislative_parameters)) reported_date,
79: trunc(fnd_date.canonical_to_date(pay_core_utils.get_parameter('REPORTED_DATE',ppa.legislative_parameters)),'YYYY') year_start_date
80: into g_pact
81: from pay_payroll_actions ppa
82: where ppa.payroll_action_id = p_payroll_action_id;
83: END IF;
84:
85: if g_debug then

Line 112: pay_payroll_actions xppa,

108: IS
109: SELECT DISTINCT asg.assignment_id,
110: asg.establishment_id
111: FROM per_assignments_f asg,
112: pay_payroll_actions xppa,
113: hr_organization_units hou1,
114: hr_organization_information hoi1
115: WHERE xppa.payroll_action_id = p_payroll_action_id
116: and hou1.business_group_id = g_pact.business_group_id --3506171

Line 126: FROM pay_payroll_actions ppa4,

122: AND asg.person_id BETWEEN p_start_person_id AND p_end_person_id
123: -- BUG 3453612
124: AND xppa.effective_date between asg.effective_start_date and asg.effective_end_date
125: AND NOT EXISTS (SELECT NULL
126: FROM pay_payroll_actions ppa4,
127: pay_assignment_actions paa4
128: WHERE paa4.assignment_id = asg.assignment_id
129: AND paa4.source_action_id IS NULL
130: AND ppa4.payroll_action_id = paa4.payroll_action_id

Line 143: FROM pay_payroll_actions ppa,

139: WHERE pei.person_id = asg.person_id
140: AND pei.pei_information6 = 'Y'
141: AND pei.information_type = 'PER_KR_HEALTH_INSURANCE_INFO'))
142: AND EXISTS (SELECT NULL
143: FROM pay_payroll_actions ppa,
144: pay_assignment_actions paa
145: WHERE ppa.effective_date BETWEEN
146: trunc(fnd_date.canonical_to_date(pay_core_utils.get_parameter('REPORTED_DATE',xppa.legislative_parameters)), 'YYYY')
147: AND fnd_date.canonical_to_date(pay_core_utils.get_parameter('REPORTED_DATE',xppa.legislative_parameters))

Line 301: pay_payroll_actions ppa,

297: FROM per_people_extra_info pei,
298: per_people_f pp,
299: per_assignments_f pa,
300: pay_assignment_actions paa,
301: pay_payroll_actions ppa,
302: hr_organization_information hhoi,
303: per_periods_of_service pds
304: WHERE ppa.payroll_action_id = g_pact.payroll_action_id
305: AND paa.payroll_action_id = ppa.payroll_action_id

Line 344: ,pay_payroll_actions xppa

340: is
341: select paa.assignment_action_id
342: ,to_number(to_char(ppa.effective_date,'MM') )
343: from pay_assignment_actions xpaa
344: ,pay_payroll_actions xppa
345: ,pay_payroll_actions ppa
346: ,pay_assignment_actions paa
347: ,pay_run_types_f prt
348: where xpaa.assignment_action_id = p_assact_id

Line 345: ,pay_payroll_actions ppa

341: select paa.assignment_action_id
342: ,to_number(to_char(ppa.effective_date,'MM') )
343: from pay_assignment_actions xpaa
344: ,pay_payroll_actions xppa
345: ,pay_payroll_actions ppa
346: ,pay_assignment_actions paa
347: ,pay_run_types_f prt
348: where xpaa.assignment_action_id = p_assact_id
349: and xppa.payroll_action_id = xpaa.payroll_action_id

Line 370: pay_payroll_actions ppa

366: IS
367: SELECT paa.assignment_action_id
368: FROM pay_assignment_actions paa,
369: per_assignments_f pa,
370: pay_payroll_actions ppa
371: WHERE pa.assignment_id = l_assignment_id
372: AND paa.assignment_id = l_assignment_id
373: AND paa.assignment_id = pa.assignment_id
374: AND ppa.payroll_action_id = paa.payroll_action_id

Line 562: l_payroll_action_id pay_payroll_actions.payroll_action_id%TYPE;

558: FUNCTION SUBMIT_REPORT
559: RETURN NUMBER
560: IS
561: l_count NUMBER := 0;
562: l_payroll_action_id pay_payroll_actions.payroll_action_id%TYPE;
563: l_bp_hi_number hr_organization_information.org_information1%type := NULL; --3506171
564: l_reported_date DATE := NULL;
565: l_number_of_copies NUMBER := 0;
566: l_request_id NUMBER := 0;

Line 579: FROM pay_payroll_actions pact,

575: IS
576: SELECT printer,
577: print_style,
578: decode(save_output_flag, 'Y', 'TRUE', 'N', 'FALSE') save_output
579: FROM pay_payroll_actions pact,
580: fnd_concurrent_requests fcr
581: WHERE fcr.request_id = pact.request_id
582: AND pact.payroll_action_id = p_payroll_action_id;
583: rec_print_options csr_get_print_options%ROWTYPE;