APPS.PSP_LABOR_DIST dependencies on PAY_PAYROLL_ACTIONS

Line 8346: token_val pay_payroll_actions.legislative_parameters%type;

8342: parameter_list in varchar2) return varchar2
8343: is
8344: start_ptr number;
8345: end_ptr number;
8346: token_val pay_payroll_actions.legislative_parameters%type;
8347: par_value pay_payroll_actions.legislative_parameters%type;
8348: begin
8349: token_val := name||'=';
8350: ---dbms_output.put_line('CDL--> Get Param --> Token, Paramlist='||token_val||','||parameter_list);

Line 8347: par_value pay_payroll_actions.legislative_parameters%type;

8343: is
8344: start_ptr number;
8345: end_ptr number;
8346: token_val pay_payroll_actions.legislative_parameters%type;
8347: par_value pay_payroll_actions.legislative_parameters%type;
8348: begin
8349: token_val := name||'=';
8350: ---dbms_output.put_line('CDL--> Get Param --> Token, Paramlist='||token_val||','||parameter_list);
8351: ---dbms_output.put_line('Paramlist='||parameter_list);

Line 8404: from pay_payroll_actions ppa

8400: g_source_code,
8401: g_time_period_id,
8402: g_batch_name,
8403: g_payroll_id
8404: from pay_payroll_actions ppa
8405: where ppa.payroll_action_id = p_payroll_action_id;
8406:
8407: if g_time_period_id is not null and g_payroll_id is null then
8408: select payroll_id

Line 8533: from pay_payroll_actions ppa

8529: g_source_code,
8530: g_time_period_id,
8531: g_batch_name,
8532: g_payroll_id
8533: from pay_payroll_actions ppa
8534: where ppa.payroll_action_id = pactid;
8535:
8536: g_business_group_id := FND_PROFILE.VALUE('PER_BUSINESS_GROUP_ID');
8537: g_set_of_books_id := FND_PROFILE.VALUE('GL_SET_OF_BKS_ID');

Line 8786: from pay_payroll_actions ppa

8782: g_source_code,
8783: g_time_period_id,
8784: g_batch_name,
8785: g_payroll_id
8786: from pay_payroll_actions ppa
8787: where ppa.payroll_action_id = p_pactid;
8788:
8789: if g_time_period_id is not null and g_payroll_id is null then
8790: --#fnd_file.put_line(fnd_file.log,'########AssignCode2#######');

Line 8843: from pay_payroll_actions ppa

8839: g_source_code,
8840: g_time_period_id,
8841: g_batch_name,
8842: g_payroll_id
8843: from pay_payroll_actions ppa
8844: where ppa.payroll_action_id = pactid;
8845:
8846: g_business_group_id := FND_PROFILE.VALUE('PER_BUSINESS_GROUP_ID');
8847: g_set_of_books_id := FND_PROFILE.VALUE('GL_SET_OF_BKS_ID');

Line 8859: from pay_payroll_actions

8855:
8856:
8857: select count(*)
8858: into l_count_fail_actions
8859: from pay_payroll_actions
8860: where payroll_action_id = pactid
8861: and action_status <> 'C';
8862:
8863: if l_count_fail_actions = 0 then